Approximate match in power query

secriera

New Member
Joined
Mar 24, 2018
Messages
1
Hello everyone,

I have 2 columns in power query.
I want to assign the best approximation to column 1 from column 2

For example: For the phrase column 1 https://www.screencast.com/t/KafThnRPS
Best match is https://www.screencast.com/t/CZiJINVA20v

in column 1 can be from 1 to 4 words compatible with column 2

Column 1
[TABLE="width: 220"]
<colgroup><col></colgroup><tbody>[TR]
[TD]
[TABLE="width: 431"]
<colgroup><col></colgroup><tbody>[TR]
[TD]BoboBaby patchwork jucarie plusata - ursulet ZW-19D[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 3 piese My Teddy bej[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 3 piese Little house [/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 3 piese Arici alb[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 3 piese Indian Boy[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 3 piese Choo-Choo galben-gri[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 3 piese Baloons[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 3 piese Choo-Choo - pink/grey[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 4 piese Little Bunny gri-pink[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 4 piese Little Bunny bej-blue[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 4 piese Little house [/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 2 piese Elefantul si Prietenii roz[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 2 piese Little Bunny gri-pink[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Elefantul si Prietenii blue[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Elefantul si Prietenii roz[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Little Bunny gri-pink[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Little Bunny bej-blue[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Little Bunny bej-pink[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese My Teddy bej[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Little house [/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Arici alb[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Bufnite[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Triunghiuri pink/grey[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Indian Girl[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Indian Boy[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Choo-Choo - pink/grey[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Teddy Moon - blue/white[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Kitties[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Choo-Choo galben-gri[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie 5 piese Baloons[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie brodata 4 piese Sleeping Teddy Bear pink[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie brodata 4 piese I love you ursulet alb-bej[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie brodata 5 piese I love you ursulet alb-bej[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie brodata 5 piese I love you ursulet roz[/TD]
[/TR]
[TR]
[TD]Klups set lenjerie brodata 4 piese I love you ursulet blue[/TD]
[/TR]
[TR]
[TD]Klups salteluta de infasat moale PM70 - Animale din padure si arici 70*50 cm[/TD]
[/TR]
[TR]
[TD]Klups salteluta de infasat moale PM70 - 016 Elefant 70*50 cm[/TD]
[/TR]
</tbody>[/TABLE]

Column 2

[TABLE="width: 220"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Scaun Multifunctional[/TD]
[/TR]
[TR]
[TD]Scaun de Masa din Lemn[/TD]
[/TR]
[TR]
[TD]Scaun de Masa cu Leagan[/TD]
[/TR]
[TR]
[TD]Gentuta de Infasat[/TD]
[/TR]
[TR]
[TD]Lenjerie Patut Bebe 3 Piese[/TD]
[/TR]
[TR]
[TD]Lenjerie Patut Bebe 4 Piese[/TD]
[/TR]
[TR]
[TD]Lenjerie Patut Bebe 2 Piese[/TD]
[/TR]
[TR]
[TD]Lenjerie Patut Bebe 5 Piese[/TD]
[/TR]
[TR]
[TD]Lenjerie Patut Bebe 6 Piese[/TD]
[/TR]
[TR]
[TD]Lenjerie Patut Bebe 7 Piese[/TD]
[/TR]
[TR]
[TD]Ham Bebe[/TD]
[/TR]
[TR]
[TD]Centura Abdominala Postnatala[/TD]
[/TR]
[TR]
[TD]Centura Prenatala[/TD]
[/TR]
[TR]
[TD]Sutien Alaptare[/TD]
[/TR]
[TR]
[TD]Chiloti Gravide[/TD]
[/TR]
[TR]
[TD]Lenjerie Unica Folosinta[/TD]
[/TR]
[TR]
[TD]Patut Masina Copii[/TD]
[/TR]
[TR]
[TD]Premergatoare 3 in 1[/TD]
[/TR]
[TR]
[TD]Antepremergator[/TD]
[/TR]
</tbody>[/TABLE]


[/TD]
[/TR]
</tbody>[/TABLE]
Thanks
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top