Forum Discussion
Solved
Update existing column value based on custom column
I have table A with the column City. I have a custom column in this table which basically does search in table B city column and if it finds it put 'Found" in that column. I would like to update th...
Is there a way to modify this so it ignores the case when comparing? It works for me when I compare "Atlanta" to "Atlanta" but it doesn't when it is "Atlanta" to "AtlanTA".
Table2WithSubstring = Table.AddColumn(#"Table A", "CitySubstringMatch", each not List.IsEmpty(List.FindText(#"Table B"[City], [City Name])))