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 |
Solved! Go to Solution.
Thank you...cool tool.