Batch Macro still dropping records

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

Batch Macro

Accepted answers

Per

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-Files-with-Different-Field/ta-p/13370

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.

All comments

Qiu

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

Attached is a good sample.

Multi Sheet Import Example.yxmd

Deba93

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

Per

Hi @Deba93

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 🙂

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703