Finding input tables

smallpotato

My input tables will change according to month. User will have to place desired input files in an empty input folder manually.

Input files example for Jan:

ABC0101A.xlsx

ABC0101B.xlsx

ABC0101C.xlsx

DEF0101.xlsx

DEF1201.xlsx

Input files example for Feb:

ABC0201A.xlsx

ABC0201B.xlsx

ABC0201C.xlsx

DEF0201.xlsx

DEF0101.xlsx

Input files example for Mar:

ABC0301A.xlsx

ABC0301B.xlsx

ABC0301C.xlsx

DEF0301.xlsx

DEF0201.xlsx

any ways that the alteryx system could read the input files in the input folder by itself, but not requiring the user to edit the files name everytime?

ChrisTX

Try a Directory tool and Dynamic Input tool.  I'm guessing each file will have a different data format/layout/schema.

After your Directory tool, you could use 5 Filter tools to get the right file name in each data stream, then use 5 Dynamic Input tools to read in each Excel file.

Chris