Find and Replace Macro

Question

Muddling my way through a find and replace macro and needs some help to get over the line.

I've set up the macro as follows, the fields im trying to cycle through and the replacements are shown in the excel input further below.  I need to feed the fields through the control parameter, I've set up the macro template and the action type as update value with the text 'Region' as the string to replace with the other fields, the replaced string adds F or R for the find or replace fields.  The Macro input tool is the data I am cleansing.  If I have a list of all field strings to replace 'Region' in the template, how do I feed that to the control parameter so it works?

The MasterDataCleanse.xlsx is as below:

Carluccio555 · Answer

The macro is outputting without an alteryx error but the find and replace isn't working in the main workflow (but works in the macro template) and also my output rows are 7 times the input rows so its multiplying the rows by the control parameter. No idea how to make this work.

Carluccio555 · Answer

The field Im replacing will change based on the control parameter, the input is now trimed to be just the 7 fields that would potentially have replacements, just field headings no data (not sure if this is necessary). Looks like this:

This is what is fed to the control parameter:

The action tool in the macro is setup like this on the find and replace:

danilang · Answer

Hi @Carluccio555

Inside your macro Input tool, remove all the columns that are not necessary for the macro to work.  Ideally this would leave only the field that you're replacing.  That will leave only the mapping question for the field that the macro will act on.  Any extra fields that are used in the main workflow will just be passed through the macro.

Dan