Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
LOAD Field
FROM ...
WHERE Match(Field,'asdfg','xyz','fsa','1234');
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
Match() function requires commas separating the values you want to compare against.
its not working,
'It's not working' is not a good issue description, could you elaborate a bit more detailed?