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 text directly above if text string is "XXX"

BosKev
8 - Asteroid

Hi all,

 

Is there a reasonable way to replace a certain text string with text above? Thanks.

 

example below:

 

replace "asabove" with text that's in the cell above it if its a different text string.

in excel I could do a "fill down( =, alt+enter key)"...is there something similar in Alteryx?

 

Sample:

Medium
Argentina,Belgium,Brazil,Colombia,France,Netherlands,Japan,Singapore,Sweden
Asabove
Argentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates
Asabove
Asabove
Asabove

 

ideal results:

 

Medium
Argentina,Belgium,Brazil,Colombia,France,Netherlands,Japan,Singapore,Sweden
Argentina,Belgium,Brazil,Colombia,France,Netherlands,Japan,Singapore,Sweden
Argentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates
Argentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates
Argentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates
Argentina,Australia,Belgium,China,France,Germany,India,Italy,Korea,Luxembourg,Netherlands,Philippines,Russia,Sweden,Switzerland,Taiwan,Thailand,UnitedStates

 

2 REPLIES 2
acastelazo
8 - Asteroid

You could use the multi-row tool to copy the row above if the current row = "asabove"

 

Capture.JPG

BosKev
8 - Asteroid

Thank you...cool tool.

Labels