Long where clause

Mon, 11 Jul 2011 05:24:22 GMT

How can I sreate long where clause? Or can I do two clauses in same LOAD statement?

I tried this one, but it doeas not work->

WHERE "kod_system" = 'EU' AND sprak = 'FI' and class= (2,5,8,3,45,98);

kaushiknsolanki — Mon, 11 Jul 2011 06:10:43 GMT

Hi,

It depends where you are using the where clause.

If you are using where clause with SQL statement then you sould do like this.

SQL Select Kod_System, Sprak, Class

From Xyz

where Kod_System = 'EU' and Sprak = 'FI' and Class in (2,5,8,3,45,98);

If you are using with Load statement then you shoudl do like this.

Load Kod_System, Sprak, Class

From Xyz

where Kod_System = 'EU' and Sprak = 'FI' and match(Class,'2','5','8','3','45','98');

Regards,

Kaushik Solanki

topic Long where clause in QlikView