Hi All, New to Alteryx. I want to join each of the parsed columns to the reference table below: Parsed column 1Parsed Column 2Parsed Column 3Parsed Column 4Parsed Column 551011079139106611955665 Reference Table: Refrence IDName1gary2greg3mike4josh5eric6adam7ian8james9ricki10derek Is there a way to do so without having multiple "join" items, one for each of the parsed columns? Thanks!

Multiple Join based off on refrence

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!

Help

Join

Accepted answers

FinnCharlton

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

Hope this helps!

Join multiple columns.yxmd

All comments

FinnCharlton

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

Hope this helps!

Join multiple columns.yxmd

binu_acs

@iacuoj47 Another method using join tool

Parsing_060623.yxmd

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703