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

[sufregs]

i have a question on using the macro. I installed it to a SharePoint location (synced to my OneDrive) and it appears to work fine for me. However when other users try to run it, they get an error 
(1001): Cannot find macro "C:\Users\username\company\SharePoint site\Batch Input\_externals\1\Batch Correct.yxmc".
when they also try to install, it prompts for an override and also says the macro path is invalid. How do I resolve this? This is my first time using Alteryx macro

[alexnajm]

This is a different topic to the original post so I'd suggest starting a new thread, but the short answer is you need to make the path relative AND make sure they have the same location synced on their machine

[sufregs]

Thank you for your response. how do i make the path relative?

[alexnajm]

I think a Google search will provide many results :)