Hello all,
I have three data source here. I would like to use "Company Name" as the main column in order to merge these three files.
I need the help to create that flow that can solve:
1. All the Company's names that are similar in structure like "abc.d","abc.c" can be replaced and made to "abc", ID columns can be added into same file.
2. "Company" column which the name has been modified needs to be replaced by the new one.
For instance:
I have these
ID | Company |
1 | abc |
2 | cde |
UID | Firm |
12 | abc.d |
34 | cde.d |
UUID | Name |
123 | abc.c |
456 | cde.c |
OUTPUT:
1.
Company Name | ID | UID | UUID |
abc | 1 | 12 | 123 |
cde | 2 | 34 | 456 |
2.
UID | Company Name |
12 | abc |
34 | cde |
Thank you.
Solved! Go to Solution.
Hi @atcodedog05
Thank you very much for your reply, but it is not suitable for my case.
The text is brief description, I attached 3 excel files (actually I have more data files, expecting a 3+ data files solution), those are the issue that I have.
Not sure how I can use "Find Replace" and "Fuzzy Match" here, or I should utilize other functions.
Happy to help : ) @k3pineapple
Cheers and have a nice day!