Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BlazkoG
Contributor III
Contributor III

left join with fuzzy matching

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 .

Labels (2)
2 Replies
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
Contributor III
Contributor III
Author

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 🙂