Files Skipped due to Schema Issues

[sufregs]

Hi All.

I am trying to import excel files into alteryx using a wildcard. However, Alteryx skips some files due to schema issues. When I compare the meta data of the first file and the skipped one, it seems Alteryx is reading one text column as V_string and the other as V_Wstring even though the data in them is quite similar.
I have tried checking the property "First line contains data" but it allows some and still skips others.

How can I resolve this?

[alexnajm · Accepted solution]

Try the batch macro located here! The Ultimate Input Data Flowchart

[abacon]

@sufregs Another option from what @alexnajm sent is this macro here - Dynamic XLSX Input Tool

Bacon