Filter Records

[#1]

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

[#2]

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.

[#3]

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)