Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Replace whole row?

rogersm01
7 - Meteor

Hi - I want to replace the word Spend with Expenditure in the following report:

 

rogersm01_1-1674638030906.png

 

Do I have to replace in each column individually or can this just be done for row 'Advertiser'?

 

At the moment, this runs through a macro that takes an age to run and ultimately comes out like this:

rogersm01_2-1674638264349.png

 

thanks.

 

4 REPLIES 4
ShankerV
17 - Castor

Hi @rogersm01 

 

You dont have to do for each column spereately.

 

Make use of the multi field formula to achieve the output.

 

Many thanks

Shanker V

ShankerV
17 - Castor

@rogersm01 

 

Please find the expected output.

 

ShankerV_0-1674638886992.png

 

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

 

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

 

Many thanks

Shanker V

 

FinnCharlton
13 - Pulsar

Hi @rogersm01

Here is the configuration of the multi-field tool that you will need to use:

FinnCharlton_0-1674639061191.png

Hope this helps

rogersm01
7 - Meteor

thanks for responses - really appreciated

Labels