Multiple Join based off on refrence

[iacuoj47]

Hi All,

New to Alteryx. I want to join each of the parsed columns to the reference table below:

Parsed column 1	Parsed Column 2	Parsed Column 3	Parsed Column 4	Parsed Column 5
5	10	1	10	7
9	1	3	9	10
6	6	1	1	9
5	5	6	6	5

Reference Table:

Refrence ID	Name
1	gary
2	greg
3	mike
4	josh
5	eric
6	adam
7	ian
8	james
9	ricki
10	derek

Is there a way to do so without having multiple "join" items, one for each of the parsed columns?

Thanks!

[FinnCharlton · Accepted solution]

Hi @iacuoj47 , you can do this by transposing your table first: 

Hope this helps!

[binu_acs]

@iacuoj47 Another method using join tool

[iacuoj47]

Thanks for this! if the left table was adjusted to include an ID such as below, how would you approach this? Table example below:

Parsed column 1	Parsed Column 2	Parsed Column 3	Parsed Column 4	Parsed Column 5	Random ID
5	10	1	10	7	123457
9	1	3	9	10	123456
6	6	1	1	9	123458
5	5	6	6	5	123459

i've thought about adding the Random ID later back in the flow, but that didn't work on the expanded data set. Essentially what i'm trying to do is have a final data set where it would look something along the lines of this:

Random ID

Transposed column Number

Transposed Column Name

Really appreciate your assistance with this!