Discussion board where members can get started with Qlik Sense.
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_code_pattern, (different length, reapeating symbols as '.')
what i need is table3:item_code,
the pattern is ex.: ab..e..... , the dots can be alphanumerical.thx in advance for any help .
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...
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 🙂