Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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 (3)
2 Replies
Highlighted

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...

Contributor II
Contributor II

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 🙂