left join with fuzzy matching

[BlazkoG]

Hi, sry for posting maybe an obvious stuff, but I'm new to qlik and couldn't find the accurate answer in topics already posted.
So I have two tables :

table1_items:

item_code,       (different lenght)

item_descriptionA

table_patterns:

item_code_pattern,     (different length, reapeating symbols as '.')

item_descriptionB

what i need is table3:
item_code,

item_descriptionA,

item_descriptionB

the pattern is  ex.:   ab..e.....  , the dots can be alphanumerical.


thx in advance for any help .

[Nicole-Smith]

I think a MapSubstring might work for you.   Details on how to use can be found here: https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFuncti...

[BlazkoG]

ok, I forgot to mention my pattern table has 29k rows, and two other columns id like to join with table with item_codes. How do I map this? Also forgot to mention I'm ultra-beginner 🙂