Hi have a WF which has multiple excel based inputs, whose schema is more or less same. For now I am running them on designer on a daily basis, but plan is to upload them to Gallery.
The problem is that often in once a month, request to add 1 or 2 new excel as input comes.
So how to update the existing WF where it can consume all excels within a folder as input.
** Crew macros as not encouraged as they crash our server.
** I have tried dynamic inputs, but even they cant pick up data coorectly.
Hi @ToxicBuoy ,
Have you tried using the Directory tool before using Dynamic input tool ? You can retrieve the list of the files then input them to the Dynamic input.
Here is the documentation : https://help.alteryx.com/20212/designer/directory-tool
yes I have tried that, but due to some difference in schema from the incoming input files, its not working.
Hi @ToxicBuoy ,
Please refer to the below a discussion on how to input multiple excel files in a folder with a different schema
Please refer to the solution wherein a batch macro is used to implement this.
Hope this helps.
Best,
Jagdeesh