Inputs Data Type

[JJJJC]

hi,

I am tasked to input all files from a folder. But Column A in one of the files is treated as a different data type which stopped it from being inputted into my workflow. How can I resolve this?

Input tool on all files - reading from \[folder name]\*.xlsx

File No.5 is not read in here

file that has a different type:

[atcodedog05 · Accepted solution]

Hi @JJJJC 

Try this macro it will read all the files sheets.

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

Hope this helps : )

[JJJJC]

hi @atcodedog05 

Thanks! This resolved my issue.

[atcodedog05]

Happy to help : ) @JJJJC 

Cheers and have a nice day!

[JJJJC]

[Removed comment]