Batch Macro still dropping records

[Deba93]

Hi Everyone,

I have built a batch macro which enables me to process a list of.xlsx files from a folder and club them together to be processed further. Now 2 of my files aren't being processed as they have schema different from the first file in the lot. I used a field info tool to check the schema and found out one column has datatype V_String and one has V_WString. Ideally it should have been resolved by batch macro. 

The error that I am getting is as below.

Any help would be great. Thanks in Advance

[Qiu]

@Deba93 
Can you embed a Select Tool in the marcro?

Attached is a good sample.

[Deba93]

The workflow seems broken as it was created on a newer version. I am using alteryx designer @Qiu

[Per · Accepted solution]

Hi @Deba93 

I think you might need yet another macro 🙂 Have a look at the solution posted here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi...

Of course, if you know that there will only be a few different schemas, you can have multiple Input, one for each schema, but that is hardly a pretty solution.

[messi007]

@Deba93 

Have you checked this on your macro:

Hope that Helps,

Regards

[Deba93]

Hi I have that option checked however the records are still dropping

[Deba93]

Thanks @Per  this actually worked. Apologies that I saw it really late. Appreciate your help 🙂