Forum Discussion

Keith011's avatar
Keith011
Helper III
3 years ago
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 ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    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's avatar
wdx223_Daniel
Community Champion
3 years ago

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"])

Keith011's avatar
Keith011
Helper III
3 years ago

Yes table 1 is unique

 

= Table.AddColumn(#"NoRegisterYesAttend","Final_Country",each #"Country Look Up Table"{[CountryCode=[#"Country/Region Name"]]}?[CountryName]? ??[#"Country/Region Name"])

 

"NoRegisterYesAttend" is my 2nd table name

"Country Look Up Table" is my 1st table name

 

but it gives me the error - Expression.Error: A cyclic reference was encountered during evaluation.