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

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 : )

Batch Input (3).yxzp