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
Solved! Go to Solution.
@Deba93
Can you embed a Select Tool in the marcro?
Attached is a good sample.
The workflow seems broken as it was created on a newer version. I am using alteryx designer @Qiu
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.
Hi I have that option checked however the records are still dropping
Thanks @Per this actually worked. Apologies that I saw it really late. Appreciate your help 🙂