Discussion Board for collaboration on QlikView Scripting.
I have a field called Cost Element that will return and I only want to include records that start with 000051 and 0000843
The field returns various cost elements and the full length is 0000510088
I want to try and do this in the laod script
Where Left([Cost Element], 6)='000051' or Left([Cost Element], 7)='0000843'
Let me know
Wildmatch([Cost Element], '000051*','0000843*)
should do the trick, use that in your load where clause to reduce down your loaded rows
hope that helps