Hi,
I want to create a New Column in the Region table that pulls the US State: in the US States table using the Abbreviation column as lookup. How do I do that?
Police Shootings.pbix (267.2 KB)
Hi @YusufGillani,
You can do that with a Merge
Go to the Regions table, select Merge (1)
Identify the Keys (2) en (3) and press OK
.
Click on the side ward arrows (1)
Select the column(s) you want to add (2), don’t use original column name as prefix (3) and press OK
.
I hope this is helpful
2 Likes
Thank you so much!