Multiple Row Vlookup & joining text

[CY712]

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

ID	Value
29	Apple
29	Pear
29	Orange
30	Banana
30	Kiwi
30	Pineapple

Table 2

Row	ID	ID
A	29	30

Desired Output

Row	ID	ID
A	Apple;Pear;Orange	Banana;Kiwi;Pineapple

[atcodedog05 · Accepted solution]

Hi @CY712 ,

Here is a workflow for the task.

Input: tables given by you.

Output:

Workflow:

Hope this helps 🙂

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

[CY712]

Works perfectly. Thanks!

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀