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

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 😀👍

Shape.yxmd