Define relationship between two tables

[Mike_Curry]

I have a table (1) that includes four separate user ID fields (CRE_USER, LAST_USER, USR_USER, REV_USER) in each record.  I am trying to bring in the username(s) associated with the user IDs from table (2) that that has the Userid and Username.

How can I create a relationship between these two tables where the output table (3) shows all the records from table 1 with the usernames for each user ID from table 2? 

[AngelosPachis · Accepted solution]

Hi @Mike_Curry ,

You will first have to transpose your table 1 to have the different column headers extend vertically instead of horizontally. After the transpose you will have a new column containing the values in a single column, which you can use as a key to join with table 2.

Then you will have to manipulate your data accordingly to bring it back in the desired format.

Hope that helps,

Angelos

[Mike_Curry]

Many Thanks Angelos!!!

I'm brand new to Alteryx... less than a week... and still learning what the tools are and when to use them.

Regards,

Mike

[AngelosPachis]

Welcome @Mike_Curry !

Step 1 ✅ and well done for leveraging the knowledge of the people in the community.

Keep on asking questions and learning from others. You can find other great resources in the community such as the help pages (https://help.alteryx.com/current/designer/tools) or the interactive lessons which I highly recommend (https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons).

Regards,

Angelos