Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to filter out the records from the Qvd file by Using Load * from tablename where fieldname in (1,2,3)
It gives Error while executing the statement but the same work in SQL, Pls suggest the option.
Thanks,
Arun
Hi Arun,
While loading the data, you cannot specify the 'in' keyword'. What you have to do is, you have to load and give the condition as given below.
Load * from tablename where fieldname = 1 or fieldname = 2 or fieldname = 3;
Just try this. This works fine for me. Hope this helps.
Thanks Joseph.
Hi Arun
I think you can also use the MATCH function instead of IN as follows:
LOAD * From TableName WHERE MATCH(FieldName,1,2,3)