Hey community,
I am facing a troublesome situation right now, maybe you guys can help me. Following:
Column_1 contains an ascending list of strings.
Column_2 contains strings mixed up in order, but basically they are a duplicate of entries from column_1.
Column_3 contains entries dependent on Column_2
what do I want to achieve:
I want to check where entry 1 from Column_1 is in Column_2 and then take the concatenated value from Column_3 and put it in row 1.
How is this possible???
in Excel I would just use match or index with an if condition somehow. but with Alteryx I dont get an ouput if I use the JOIN Tool as the first entries of Column_1 and Column_2 do not match. And it is not looking any further down in Column_2 to find it. So it just stopps.
PLEASE HELP ME ;)
Coco
