Forum Discussion
Compare text (names) in two columns in the same table
Hello I want to compare the names in the column 1 and column 2 of the same table. Let's say A B John Carry Carry John Ivan Mathew Ro...
Since the fuzzy join did the match for you, just use a formula like this:
if [column1] = [column2] then [column1 phone] else [column2 phone]This assumes you brought in both phone numbers from these two tables.
edhans
Community Champion
Community ChampionSince the fuzzy join did the match for you, just use a formula like this:
if [column1] = [column2] then [column1 phone] else [column2 phone]This assumes you brought in both phone numbers from these two tables.