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,

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.

Update data and save new file.yxzp