Combine similar columns from different source

[k3pineapple]

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.

[atcodedog05]

Hi @k3pineapple 

Here is how you can do it.

Workflow:

Hope this helps : )

[k3pineapple]

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.

[binuacs]

@k3pineapple 

[atcodedog05 · Accepted solution]

Hi @k3pineapple 

My take on this

Hope this helps : )

[atcodedog05]

Happy to help : ) @k3pineapple 

Cheers and have a nice day!