Hi all,
In my data input, I have two rows of columns that are similar to each other. [Account Name] being the reference column and [Organization] column that I am trying to manipulate. I want to replace the words in the [Organization] column with the true naming convention column, [Account Name].
I am not sure of the workflow on how to achieve this? Fuzzy Match or Find and Replace?
Input
Organization | Account Name |
Desert Oasis Health Care | Telecare Corporation |
Telecare | Desert Oasis Healthcare |
AAA of Tidewater | Riverside County Office of Education-Corona Norco USD |
Riverside County Office of Education-Palm Springs USD | AAA Tidewater Virginia |
Riverside County Office of Education-Corona Norco Unified School District | AAA Texas |
AAA of Texas | Riverside County Office of Education (RCOE)-Palm Springs USD |
Desired Row Output
Organization |
Desert Oasis Healthcare |
Telecare Corporation |
AAA Tidewater Virginia |
Riverside County Office of Education (RCOE)-Palm Springs USD |
Riverside County Office of Education-Corona Norco USD |
AAA Texas |
Thanks @ArtApa
This is great! I am having trying to replicate this when there are two inputs.
How would the workflow look?
Input 1 Input 2
Organization | Account Name |
Desert Oasis Health Care | Telecare Corporation |
Telecare | Desert Oasis Healthcare |
AAA of Tidewater | Riverside County Office of Education-Corona Norco USD |
Riverside County Office of Education-Palm Springs USD | AAA Tidewater Virginia |
Riverside County Office of Education-Corona Norco Unified School District | AAA Texas |
AAA of Texas | Riverside County Office of Education (RCOE)-Palm Springs USD |
Desired Row Output
Organization |
Desert Oasis Healthcare |
Telecare Corporation |
AAA Tidewater Virginia |
Riverside County Office of Education (RCOE)-Palm Springs USD |
Riverside County Office of Education-Corona Norco USD |
AAA Texas |