Avoiding duplicates in a one to many join

[Nageen]

Hello,

I am trying to create a one to many join where a column from one source of data should be joined with three columns from the other source of data. A regular join tool with three keys is not working. See below for some sample data. 

Role 1	Role 2	Role 3
Mom	Wife	Daughter
Dad	Husband	Son

Role

Mom

Dad

Wife

Husband

Daughter

Son

The current keys were: (Role, Role 1) (Role, Role 2) and (Role, Role 3)

Any guidance on what I'm doing wrong would be appreciated. Thank you!

[Garrett · Accepted solution]

How about pivoting the data before joining it (i.e. Transpose tool)?

[Thableaus · Accepted solution]

Hi @Nageen 

Is this what you want?

Cheers,

[Thableaus]

Sorry, didn't see your solution @Garrett 

Cheers,