Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how can i use load statement

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~

4 Replies
anbu1984
Master III
Master III

Connect ....;

Sql

select *

from wpprd

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

Not applicable
Author

A:

load a,

     d,

     c,

     d

from ~~~~ (qvd);

sql select a, d

from ~~~(qvd)

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

it is possible??

anbu1984
Master III
Master III

A:

load a,

     d,

     c,

     d

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
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.