Combine similar columns from different source

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:

Company Name	ID	UID	UUID
abc	1	12	123
cde	2	34	456

UID	Company Name
12	abc
34	cde

Thank you.

Sample Data 2.xlsx

Sample Data 3.xlsx

Sample Data 1.xlsx

Fuzzy Match

Accepted answers

atcodedog05

Hi @k3pineapple

My take on this

Hope this helps : )

Company.yxmd

All comments

atcodedog05

Hi @k3pineapple

Here is how you can do it.

Workflow:

Hope this helps : )

Company.yxmd

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. Error 1.PNG

binu_acs

@k3pineapple

combine1.yxmd

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335