Discussion board where members can get started with QlikView.
I am sitting with a problem. I need to do a WildMatch for 3000 lines of data... But the WildMatch function only allows 100 lines?
Please does anyone have a way to get around this problem or maybe another function that i can use?
Added an Example with notes in the Script
If I may ask, why are you wildmatching that many values? Would it not be better to load an excel or .txt file with the value you are widmatching to and then use applymap() to get the desired result.
Having that many wildmatches is going to be a maintenance nightmare
This item on using wildcards with ApplyMap may help
I agree with Byron
What do you want to do ? Just wildmatch because you love that function ?? Or sth for your user ?
Tell us what you wanted to achieve before thinking to wildmatch: there is perhaps sth simple...
Please see my attachment. My notes are in the script