Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
alexandros17
Partner - Champion III
Partner - Champion III

Load

...

From

...

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

Let me know

Not applicable
Author

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