Hi everyone,
I am dealing with an issue about concatenate multiples csv files.
So I'am using, the Directory Tool to get all directory for each files and then I'm using the Dynamic Input to read all Files.
I have voluntarily uncheck the headers columns options because I wanted to check if there are sames columns for each files. So i need to have the headers for each files.
Finally, I noticed that there are columns not in the same orders, I give you this example to understand :
Fields 1 | Fields 2 | Fields 3 | Fields 4 | Fields 5 | Fields 6 | Fields 7 | Fields 8 | Fields 9 | Fields 10 |
Id | Name | City | Postcode | Country | Area | GPS 1 | GPS 2 | Sales | Price |
1 | John | London | C2N 5DU | UK | 1,572 | 10,5 | 12,6 | 7 | 210 |
2 | Mark | Boston | 2500 | USA | 2500 | 2,55 | 3,78 | 15 | 615 |
3 | Paul | NY | 6800 | USA | 3500 | 1,65 | 3,255 | 1 | 42 |
4 | Mike | Madrid | 4890M | SP | 1400 | 15,25486 | 13,1558 | 23 | 805 |
5 | Judith | Milan | 8996 | IT | 1500 | 10,002 | 11,2589 | 6 | 60 |
Id | Name | City | Postcode | Area | Country | GPS 1 | Sales | GPS2 | Price |
15 | Parker | Manchester | CT4 369 | UK | 15,1 | 48 | 15,699 | 4368 | |
13 | Jennifer | Chicago | 4500 | USA | 12,1 | 37 | 14,255 | 323 | |
14 | John | Dallas | 2690 | USA | 10,3 | 12 | 13,0225 | 4465 | |
12 | David | Texas | 4560 | USA | 14,9966 | 91 | 12,0222 | 1764 | |
11 | Peter | Barcelona | 4590B | SP | 12,2555 | 72 | 10,255 | 2916 | |
8 | Samantha | Tokyo | 10266 | JP | 10,5555 | 8 | 11,02255 | 798 |
So I don't know how to organize the columns. I tried to use the Transpose Tool, but I did not succeed.
I don't know if it's possible to concatenate each file step by step by ordering the right columns together ?
Thank you for your help.
Solved! Go to Solution.
You can use a Batch macro in order to that,
1- Create a batch macro to read a CSV file
2- Select the option below from the interface designer
3- Use an input directory to read all the files
Attached the packaged workflow,
If this help please mark it as solved it will help others 🙂
Best Regards,