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 Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

looking for something like the match function- HELP

die_Corinna
5 - Atom

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

2 REPLIES 2
CharlieS
17 - Castor
17 - Castor

@die_Corinna

 

Do you have a sample input you can share for us to work with?

die_Corinna
5 - Atom