In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Inputs Data Type

JJJJC
7 - Meteor

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

JJJJC_0-1642693354122.png

 

file that has a different type:

JJJJC_2-1642693430692.png

 

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

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
7 - Meteor

hi @atcodedog05 

 

Thanks! This resolved my issue.

 

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @JJJJC 

Cheers and have a nice day!

JJJJC
7 - Meteor

[Removed comment]

 

 

Labels
Top Solution Authors