Merge Table with multiple possibilities

[helpmeonPBI]

Hello,

I am looking to get country info based on multiple filters

I have 2 tables

Table 1

Code1	Code2	Code3	KEY	Country
NL20	1245	C4434	NL20.1245.C4434
NL20	1246	C4434	NL20.1246.C4434
NL22	1247	C4436	NL22.1247.C4436
NL23	1248	C4437	NL23.1248.C4437

Table 2 is the mapping table with filter including special caracter meaning all field

For istance row 1 Nevertheless Code 1 and Code 3 if Code 2 is 1245 it's France

Key	Country
*.1245.*	France
*.*.C4434	Spain

Do you have an idea how I can process this ?

Thanks you so much for your help,

Olivier

[Thingsclump]

Hi @helpmeonP

For row 1 in table 1, country is France or Spain? It has both 1245 and C4434. Any preference?

Thingsclump

www.thingsclump.com 

[helpmeonPBI]

Hello,

Any preference let's imagine this configuration will not exist.

Olivier

[helpmeonPBI · Accepted solution]

Hello,

I find the answer on this great post.

https://community.powerbi.com/t5/Power-Query/Merge-tables-using-wildcards/td-p/1463971

Have a nice WE,

Olivier