Account for field names changing

I have a macro that has a macro nested in it. One of the macros has two input files that I join together. There are three macro outputs too. I tried adding three select tools at the end and then mapping one of the macro inputs to each of those select tools, using the "Update Select with Reverse Field Map" option. But when I go to use the macro in a workflow I get a error that the field "Store" is not contained in the record. It's not, because the new data is using "Shop". Not sure how to fix this!

Macros

Dynamic Processing

Accepted answers

JoeS

Hi @gwiz

I have attached a very simple version here:

The formula set up my dummy fields. I prefix them with "NonRepeatable" so not to ever overwrite an existing column on your data, in the assumption you won't have a field called "NonRepeatableJoinField1", whereas JoinField1 may, although unlikely, exist on your data.

The Dynamic select can then remove my dummy/working fields by !Contains([Name], "NonRepeatable")

JoinData.yxmc

All comments

ddiesel

Hi @gwiz !

In the macro, check out the Interface Designer Settings - Properties. Under "Output Mode", the default is "All Iterations will have the same output schema (Error if different)". Try either Auto configure by Name or Auto Configure by Position.

Let us know if this resolves your issue. If not, there are a couple other ways to tackle it.

gwiz

@ddiesel thanks

That works if it is a batch macro. I changed it to a batch but now it doesn't work by doing that. 😕

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703