Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

adding a where condition

i need to limit my load with some where condition in my script where x='asdjfj'  like thi there are 10 values ,how to do that ,

if am just direct writing like x='bfjbdj','jdfhjhj','sdhfjsdgfj' ..........................................like this for 10 values

after my load statement ,its showing wrong syntax.

5 Replies
swuehl
MVP
MVP

LOAD Field

FROM ...

WHERE Match(Field,'asdfg','xyz','fsa','1234');

Anonymous
Not applicable
Author

FROM

[\QVD\.qvd]

(qvd) where x<>'-9999' and y='Sat' and Match(z,

'1610023353422|Z14N142927'

'1591060447759|Z16N226152'

'2199996076857|Z15N401814'

'2000016218700|Z16N063696'

'1900037188652|Z16N173636'

'2000026037752|Z15N413836'

'2310296834017|Z16N140769'

'1610020185660|Z16N215765'

'1610027257568|Z13QU58933'

'1610002252481|Z16QU45021')

this is gvng me syntax error

swuehl
MVP
MVP

Match() function requires commas separating the values you want to compare against.

Anonymous
Not applicable
Author

its not working,

swuehl
MVP
MVP

'It's not working' is not a good issue description, could you elaborate a bit more detailed?