Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

Batch processing files in a directory

ccarreras
7 - Meteor

I have a directory that contains 61 small files that all have the same schema. I know how to use the union operation to manually combine these files, but it's going to take a long time. Is there a way to have Trifacta automatically apply a recipe to all 61 files?

3 REPLIES 3

When you select data you can define a folder as a Trifacta dataset, and then in this case all files stored in the folder will be seen as only one large file. No more union need to work on all files at the same time.

ccarreras
7 - Meteor

Wow, that's such a time saver! So I assume if more files end up in that folder, Trifacta will just automatically add those new files into the single large file?

Yes, all new small files will be part of the large logic file seen via Trifacta. And any job running on the large file will include data from new small files.