Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

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
Top Solution Authors