Discussion board where members can get started with Qlik Sense.
because the word "art" is also in the word "smart" it show the name field with word smart in art group
May be use MapSubString with ApplyMap in the script to do this
Load script find value from one table as substring | Qlik Community
=Pick(WildMatch limited to 200 record , i have over 800 record, when i insert over 200 record it give me an error any advice how to use grouping with expression that can hold over 800 record
expression i use:
'*Father*',+ 1, 'Other',
This doesn't look right to me... it should be this
'*Father*') + 1, 'Other',
still show error if i insert over 200 record, (200 record 400 line)
I have not heard of a limit, but I have not also tested with such a long Pick(Match()) statement... have you considered using Mapping load with ApplyMap in the script?
i did not try the Mapping load, that will be great if you can direct me how to do it
Don't join - use Applymap instead