Fix data type in a file

[Anuj_saxena01]

hi Experts,

I am reading few excel files in batch using processing (example-  \*.xlsx) via input tool. But due to different schema in few files. Alteryx is showing warning and skipping those files. Is there a way to change columns data type before it is getting read in alteryx. or we can fix the data type?

example- Column C in file ABC is double but in file XYZ is string. So file XYZ is getting skipped while reading all files in folder.

[atcodedog05 · Accepted solution]

Hi @Anuj_saxena01 

You can try the 3rd method of this article for the usecase to read files of slightly different schema.

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

There is no way to change the datatype of input files before reading it in.

Hope this helps : )