Forum Discussion
Solved
Comparing two columns with addresses
I'm trying to compare two columns. Each column has the address. I'm trying to create another column that says True or False if the two columns match or not. The issue that I'm having is if the addres...
moatazbelah
You can add a custom column as follows= Text.Contains([address 1],[address 2],Comparer.OrdinalIgnoreCase) or Text.Contains([address 2],[address 1],Comparer.OrdinalIgnoreCase)
moatazbelah
You can add a custom column as follows
= Text.Contains([address 1],[address 2],Comparer.OrdinalIgnoreCase) or Text.Contains([address 2],[address 1],Comparer.OrdinalIgnoreCase)