My scenario parses 2 separate CSV files that share a reference number. I’m trying to connect the data into one combined CSV file, connected by that reference number. CSV file # 1 is the smaller data set. CSV file# 2 is the larger data set. I don’t want the reference numbers in CSV file# 2 that do not occur in CSV file #1.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Add columns from multiple CSV file into one CSV file | 2 | 56 | January 9, 2025 | |
| Merging CSV files - array aggregators or iterators? | 8 | 45 | December 17, 2025 | |
| Comparing between 2 Excel files | 7 | 408 | July 30, 2024 | |
| Getting stuck on simple multiple dataset issue | 3 | 130 | August 6, 2024 | |
| I want to connect spreadsheet in a way that it routs certain rows in different spreadsheets | 2 | 67 | September 23, 2024 |