Reading multiples csv files with differents columns orders

[ByranCarter12]

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.

[messi007 · Accepted solution]

@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,