topic Re: load from database where field IN in QlikView

load from database where field IN

didierodayo — Tue, 26 Jul 2016 01:22:32 GMT

Hello I need some help with this script please.

I have tried this and it is not working. I ma loading from the database.

Provider_Service:

LOAD STUDENT_ID,

NAME,

AGE

WHERE STUDENT_ID = ('00345','00360','00370','00240','00320','00700')

SQL SELECT *

FROM DWH."STUDENTDTLS";

I have also tried and not working aswell.

SET vTOPID= ('00345','00360','00370','00240','00320','00700')

Provider_Service:

LOAD STUDENT_ID,

NAME,

AGE

WHERE STUDENT_ID = $( vTOPID)

SQL SELECT *

FROM DWH."STUDENTDTLS";

What am I doing wrong?

Thanks

Didier

Re: load from database where field IN

Tue, 26 Jul 2016 01:38:15 GMT

filter:

load * inline [

STUDENT_ID_key

'00345',

'00360',

'00370',

'00240',

'00320',

'00700'

];

LOAD STUDENT_ID,

NAME,

AGE

WHERE exists (STUDENT_ID_key,STUDENT_ID)

SQL SELECT *

FROM DWH."STUDENTDTLS";

LOAD STUDENT_ID,

NAME,

AGE

WHERE STUDENT_ID='00700' or STUDENT_ID='00320' .....

SQL SELECT *

FROM DWH."STUDENTDTLS";

or direcly on sql:

LOAD STUDENT_ID,

NAME,

AGE

SQL SELECT *

FROM DWH."STUDENTDTLS" where STUDENT_ID like "00700" or ....;

Re: load from database where field IN

didierodayo — Tue, 26 Jul 2016 01:46:21 GMT

Hi Rodrigo,

I like the first option, but what if am applying the filter to multiple tables that are not joined, can I do something like this?

filter:

load * inline [

STUDENT_ID_key

'00345',

'00360',

'00370',

'00240',

'00320',

'00700'

];

TableA:

LOAD STUDENT_ID,

NAME,

AGE

WHERE exists (STUDENT_ID_key,STUDENT_ID)

SQL SELECT *

FROM DWH."STUDENTDTLS";

TableB:

LOAD STUDENT_ID,

ADDRESS,

NUMBER

WHERE exists (STUDENT_ID_key,STUDENT_ID)

SQL SELECT *

FROM DWH."STUDENTCONTACT";

Re: load from database where field IN

sunny_talwar — Tue, 26 Jul 2016 01:51:35 GMT

May be like this:

filter:

load * inline [

STUDENT_ID_key

'00345',

'00360',

'00370',

'00240',

'00320',

'00700'

];

TableA:

LOAD STUDENT_ID,

NAME,

AGE

WHERE exists (STUDENT_ID_key,STUDENT_ID)

SQL SELECT *

FROM DWH."STUDENTDTLS";

Left Join (TableA)

LOAD STUDENT_ID,

ADDRESS,

NUMBER

SQL SELECT *

FROM DWH."STUDENTCONTACT";

Re: load from database where field IN

didierodayo — Tue, 26 Jul 2016 01:59:43 GMT

Thanks Rodrigo and Sunny. Much appreciated.