Wondering How to Best Fuzzy Merge Multiple Datasets to Compare

[Anonymous]

I work for an organization that is working through customer consolidation in different systems. Each system has a different naming convention for each customer but I need to see which customers work with various business lines. I'm not sure the best practice in merging these 4 datasets.

I've put in a column that basically designates a client of a specific business line, I'll do a fuzzy merge to see which ones align in each dataset, I'd assume from there you can just append the queries but that ends up having weird results where they create multiple line items.... example:

Ultimately I'd like it to be like this:

Its been tricky for me. I'd appreciate the help... still a noob.

[Anonymous]

Hi @Anonymous ,

You can use fuzzy merge in Power Query. More details you can refer to Create a fuzzy match (Power Query).

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I understand how to do the basic fuzzy merge. The problem is when I do so there are multiple line items like my first picture example. 

[Anonymous]

Hi @Anonymous ,

You can hold down ctrl and select multiple

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I appreciate you trying to help, but its not just multiple line items from 2 tables... there are 4 different queries I have to compare to one. 

[Anonymous]

Hi @Anonymous ,

Well, assuming four tables A, B, C, and D, you can first merge A and B to get a new table E, then merge C and D to get a new table F, and then merge E and F to get a final table G.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.