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

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

example.yxmd