How to input multiple files with same initial file names using a single tool?

[garvit1495]

I have 4 files with the below file names. Can I input these together using a single tool?

Market Insight A 01022022.xlsx, Market Insight B 01022022.xlsx, Market Insight  01022022.xlsx and Market Insight A 01022022.xlsx

[JosephSerpis]

Hi @garvit1495 have a look at this article it will explains how to tackle your challenge.

[KrishnaChithrathil]

yes you can.

Drag Input Tool then give path\Market Insight *.xlsx

[grazitti_sapna · Accepted solution]

@garvit1495 , you can accomplish this by using an input data tool with the below configuration, it will union all the data from all the 4 files. But please note that the order and number of f shields should match in all 4 files, otherwise it will not give you the correct output.

Thanks!!

[Alteryx_AR]

@garvit1495 Replace the filename portion of the path with a wildcard “*” in the input tool. 

Please refer to The Ultimate Input Data Flowchart - Alteryx Community 

Thanks