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 Designer Desktop Discussions

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

Multiple Row Vlookup & joining text

CY712
5 - Atom

Hi,

 

I have below two tables, would like to look up for the ID and then join the multiple values using ";". Is this achieve in alteryx?

 

Thanks in Advance.

 

Table 1

IDValue
29Apple
29Pear
29

Orange

30

Banana

30

Kiwi

30

Pineapple

 

Table 2

RowIDID
A2930

 

Desired Output

RowIDID
AApple;Pear;OrangeBanana;Kiwi;Pineapple

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @CY712 ,

 

Here is a workflow for the task.

 

Input: tables given by you.

Output:

atcodedog05_2-1601898009088.png

Workflow:

atcodedog05_3-1601898024124.png

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

CY712
5 - Atom

Works perfectly. Thanks!

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂

 

Cheers and happy analyzing 😀

Labels