community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

replace text directly above if text string is "XXX"

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

 

Highlighted
Asteroid

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

 

Capture.JPG

Asteroid

Thank you...cool tool.

Labels