Reading in multiple files

Question

Hi,

I am reading multiple files using wildcards(*) in file name but for a particular sheet the input tool in not reading in all the files despite the sheet name being same. Could anyone please help me, why it is not reading the file?

Regards,

Mustafa

Kaustubh17 · Answer

Hi @MKanchwa and @atcodedog05

The article which suggested by @atcodedog05 will definitely resolve your issue.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/tac-p/803928#M6729

Thanks,

Kaustubh

atcodedog05 · Answer

Hi @MKanchwa

This problem happens even when there is slight change in formatting it will skipped because of different formatting. You can use the 3rd method in the below article to read all files with different formatting.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Hope this helps : )