Batch Import with Dynamic Select

JunePark

Hi,

I'm trying to import multiple Files/Sheets.

Since they Have different Schemas,  I want the user to select the column numbers for specific fields.

I'm starting off the batch macro as below.

This works fine for most cases.

However, if some sheets does not have the specific column(for example, the vendor info column), I'm not sure how to handle this. (Of course, the macro results in errors if I input a 0 or non numeric value such as "N/A")

I can use a detour tool if I know how many columns can have N/A values, but I want to make the macro a bit more dynamic.

Does anyone have a solution for this??

Thanks.

Jonathan-Sherman

Hi @JunePark,

I would create your (1,2,3,4,5,6,7) part of your Dynamic Select IN statement outside (using a summarise tool) and use a batch macro to pass the value into a dynamic select tool formula.

You may notice i'm filtering to remove 0s - this is to stop you bringing in any columns you don't want to or don't have (by using 0).

This concatenation creates the IN() list of field numbers to keep:

This list is passed into the batch macro to dynamically select the field numbers you wanted:

If this solves your issue please mark the answer as correct, if not let me know! I've attached a packaged workflow containing all of the macros and dependencies used.

If you've got any questions feel free to ask!

Regards,
Jonathan

Dynamic Select Columns.yxzp