Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Including records that have a certain criteria

Hi

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

2 Replies

Re: Including records that have a certain criteria

Load

...

From

...

Where Left([Cost Element], 6)='000051' or Left([Cost Element], 7)='0000843'

Let me know

Not applicable

Re: Including records that have a certain criteria

Hi Andrew,

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

Joe

Community Browser