Chaining Apps

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

Alteryx photo.png

Developer

Developer Tools

Chained App

Accepted answers

alexnajm

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!

All comments

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

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703