Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Replace whole row?

rogersm01
6 - Meteoroid

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
12 - Quasar

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
12 - Quasar

@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
11 - Bolide

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
6 - Meteoroid

thanks for responses - really appreciated

Labels