Joining two datasets

[AlteryxLearner23]

Hi,

Using the attached file, I want to bring in the column 'Metro' from the 'New Data' tab into the 'RAW DATA' tab.

I think we can do this by using the 'ID' in both tabs, but not sure how?

Can someone help?

Thanks

[ShankerV]

Hi @AlteryxLearner23 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @AlteryxLearner23 

Step 1: Input the dataset

Step 2: 

Step 3:

Many thanks

Shanker V