Migrate files of different schemas from one folder to another

[E_Sinha_home]

Hello

I have around 200 csv files (each with a different data structure). I want Alteryx to pull each file (one at a time), take the 1st row as header, and then save that file in another folder (for example say in the Output folder).
Then again take the 2nd file and perform the steps and save, then again the 3rd and so on.

Is this possible?

Note: I tried doing this using batch macro. But the issue that i am facing is that the data is getting stacked one below the other and so for every output data i am having n number of columns with nulls.

Thanks in advance!

[T_Willins]

Hi @E_Sinha_home,

Can you provide a sample of  data in a couple of dissimilar files and how you would like it to look in the output file?

[E_Sinha_home]

Hey @T_Willins,

PFA 2 sample input files.. I want the outputs as the output files attached herein.

Thanks!

[T_Willins · Accepted solution]

Hi @E_Sinha_home,

A batch macro will work, but instead of outputting to a Macro Output tool, it uses a standard Output Data tool to create a new file for each batch.  I used the Input Data tool to skip the first row, then used a Formula tool to update the filepath for the output.  Look at the configuration of the Input Data tool and the Output Data tool for the correct configurations.

[E_Sinha_home]

Thank you so much ! That wonderfully works ! 🙂