Chaining Apps

[fieldew1]

Hi,

I'm trying to do something I have never done before. I have multiple files with dynamic sheet names and some of them have an additional columns. I have tried batch macro but due to I believe dynamic sheet names this doesnt work. I have read that I should try chaining apps - APP1 to get sheet names APP2 batch macro but I'm stuck with configuration. The files are in .csv format so how can I retrieve the sheet name? Any help would be much appreciated. Thanks

[alexnajm]

If your files are in CSV format, it's not possible to have multiple sheets - a regular batch macro should work fine if you are just reading in multiple CSVs. Can you clarify your ask?

[fieldew1]

Thanks for getting back to me. I have used directory with CSV files up to recently when some additional columns have been added which impacted the schema so in the process of reading files the ones which don't match the previous format get skipped. I have tried batch macro but names of sheets within each file differ - they take the file name and date partially which makes them dynamic. So when I use batch macro (unless I haven't configurated it correctly) it picks up only the file I used when configuring the macro. I hope this makes sense.

[alexnajm · Accepted solution]

You should only need to pick up the file name since you are reading CSVs - sheet names are not relevant since there's only one "sheet" per CSV so it'll default to the only sheet available no matter the name

You can try the Dynamic CSV Input Tool - Alteryx Community built by @abacon as a baseline!

[fieldew1]

Thank you so much! The macro worked perfectly!

Just a question, if files have a different schema, does the macro matches them by column? Just wondered if any of the files had a different order of columns would they still append correctly?

[alexnajm]

It is set to autoconfigure by column name

[fieldew1]

Amazing! Thanks @alexnajm!