topic Re: how can i use load statement in QlikView

how can i use load statement

Thu, 30 Oct 2014 01:35:27 GMT

i want use

select *

from wpprd

where aa='b' and in ( select * from wiplot);

but in edit script, i don't know how use it..

please help me~

anbu1984 — Thu, 30 Oct 2014 01:44:07 GMT

Connect ....;

Sql

select *

from wpprd

where aa='b' and field in ( select field from wiplot);

Thu, 30 Oct 2014 02:00:39 GMT

load a,

from ~~~~ (qvd);

sql select a, d

from ~~~(qvd)

where a=1 an d in (select * from A);

it is possible??

anbu1984 — Thu, 30 Oct 2014 02:06:48 GMT

load a,

from ~~~~ (qvd);

//If you are reading from qvd then sql is not required

sql select a, d

from ~~~(qvd)

where a=1 and Exists(d);

jagan — Thu, 30 Oct 2014 02:15:37 GMT

Hi,

Can you come with a sample values and your expected output?

Regards,

Jagan.