Forum Discussion

MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
3 years ago
Solved

Compare 2 tables YES/NO - IGNORE upper/lower case

Hi.

 

this is my code.
Table.AddColumn(#"prev step", "Custom", each if [column1] = [column2] then "Yes" else "No")

I would like this to ignore upper/lower  case difference 
eg.
Jacket / JACKET , shirt / SHIRT   all this should be "Yes"

 

Is there a way to do it please?

Need Help
  • CNENFRNL's avatar
    CNENFRNL
    3 years ago
    Table.AddColumn(#"prev step", "Custom", each if Text.Upper([column1]) = Text.Upper([column2]) then "Yes" else "No")

2 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    3 years ago
    Table.AddColumn(#"prev step", "Custom", each if Text.Upper([column1]) = Text.Upper([column2]) then "Yes" else "No")