topic How to implement SQL server in () using Qlikview? in QlikView

How to implement SQL server in () using Qlikview?

fionna51 — Thu, 14 May 2015 20:24:09 GMT

I just have a simple question. When I select in SQL server, I may use:

select *

from table a

where a. someID in (1,2,3,4)

How to do it in Qlikview?

And, when I LOAD following, how to do the IF better?

LOAD if (ID = 1 or ID =2 or ID =3 or ID =4 or ID =5, 'special', ID) AS newID

Resident tableB;

petter — Thu, 14 May 2015 20:42:09 GMT

You can write this:

Match( someID , 1,2,3,4 )

You can use this both in a LOAD statement in a WHERE-clause and in the field/column part of a load.

So the last could be writen:

LOAD

If( Match( ID , 1 , 2 , 3 , 4 , 5 ) , 'special' , ID ) AS newID

RESIDENT

tableB;

fionna51 — Thu, 14 May 2015 20:48:12 GMT

Thanks a lot.