WF using multiple and increasing inputs

Question

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.

JagdeeshN · Answer

Hi @ToxicBuoy ,

Please refer to the below a discussion on how to input multiple excel files in a folder with a different schema

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Import-multiple-excel-file-different-schema-and-union/td-p/533496

Please refer to the solution wherein a batch macro is used to implement this.

Hope this helps.

Best,

Jagdeesh

ToxicBuoy · Answer

yes I have tried that, but due to some difference in schema from the incoming input files, its not working.

Jean-Balteryx · Answer

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