Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?