Forum Discussion
Solved
Easy match and return help
Hi there. I have a simple task but just can't figure it out. This is table1 countryCode countryName HK Hong Kong MY Malaysia SG Singapore CN China This is table2 ...
if the rows of table 1 is unique, then try this code:
NewStep=Table.AddColumn(Table2,"Final_Country",each Table1{[CountryCode=[#"Counrty/Region Name"]]}?[CountryName]? ??[#"Counrty/Region Name"])
wdx223_Daniel it's working now! so sorry , some typo of the column names.
1 question : what does the "?" do in your solution?