Where Condition

[upaliwije]

Hi Friends

WHERE BRA_CODE =('AL00' 'AP00' 'AA00')

When I load data I have added the above where clause in my sql. But it is not working . Pls correct me

[its_anandrjs · Accepted solution]

Try with

WHERE Match(BRA_CODE,'AL00','AP00','AA00')

and what is your complete SQL script let me know

[jagan]

Hi,

Use In

WHERE BRA_CODE IN ('AL00' 'AP00' 'AA00')

Regarsd,

Jagan.

[rbecher]

WHERE BRA_CODE IN ('AL00', 'AP00', 'AA00')

[jagan]

Hi,

If you want to use in Qlikview Script then try like this

WHERE Match(BRA_CODE, 'AL00' 'AP00' 'AA00')

Regards,

Jagan.

[rbecher]

..would be much better to use the Where Clause on SQL level than LOAD level! This prevents a lot of traffic from the database to QlikView.