Error in changing the Field Mapping using Alteryx Macro

[Rihan_Mohamed]

I'm facing some errors while creating Alteryx macro. indeed of help.

Below is the screen shot of the data which I have.

My requirement is to change the column name A/C to GL Account Number  and BU to Business Unit and Amt to Amount.

For that I have created a macro with drop down tool and i'm facing some error. Below is the screenshot of the macro.

The Final workflow looks like the screenshot below.

Final Result Expected Using Macro

I have also attached the workflow for your reference.

[Rihan_Mohamed]

@deviseetharaman  I used the below settings please refer the screenshot.

But cannot get the output its shown as null.

[deviseetharaman · Accepted solution]

Its working for

[Rihan_Mohamed]

@deviseetharaman  

Thank you so much this works fine.