Reading multiples csv files with differents columns orders

Question

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 1Fields 2Fields 3Fields 4Fields 5Fields 6Fields 7Fields 8Fields 9Fields 10IdNameCityPostcodeCountryAreaGPS 1GPS 2SalesPrice1JohnLondonC2N 5DUUK1,57210,512,672102MarkBoston2500USA25002,553,78156153PaulNY6800USA35001,653,2551424MikeMadrid4890MSP140015,2548613,1558238055JudithMilan8996IT150010,00211,2589660IdNameCityPostcodeAreaCountryGPS 1SalesGPS2Price15ParkerManchesterCT4 369 UK15,14815,699436813JenniferChicago4500 USA12,13714,25532314JohnDallas2690 USA10,31213,0225446512DavidTexas4560 USA14,99669112,0222176411PeterBarcelona4590B SP12,25557210,25529168SamanthaTokyo10266 JP10,5555811,02255798

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.

messi007 · Accepted Answer

@ByranCarter12,

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,