Alteryx Designer Desktop Discussions

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

Replace specific text with specific text in the row above

D_Y
8 - Asteroid

I have text that looks like this

 

Field Name
Alpha Additions
Field_1_1 Upgrades
Field_1_2 Subtractions
Bravo Additions
Field_1_3 Upgrades
Field_1_4 Subtractions

 

I am trying to cleanse the text so that it looks like this

Field Name
Alpha Additions
Alpha Upgrades
Alpha Subtractions
Bravo Additions
Bravo Upgrades
Bravo Subtractions

 

I know this likely involves the Multi-Row Formula with maybe a Parse or Regex formula, but was unable to combine all this together to get it to work.

 

Any help would be appreciated!

4 REPLIES 4
binuacs
20 - Arcturus

@D_Y One way of doing this with the Multi-Row formula tool

binuacs_0-1682086603522.png

 

Deano478
12 - Quasar

Hey @D_Y  this is a longer way but you can achieve the result

D_Y
8 - Asteroid

Thank you!

D_Y
8 - Asteroid

 Thanks as well!

Labels