topic How can we write this SQL query in edit script in QlikView

How can we write this SQL query in edit script

kkkumar82 — Tue, 22 Mar 2016 13:17:27 GMT

All,

How can we write this query in edit script. Attached is a pic.

Kiran Kumar

Re: How can we write this SQL query in edit script

Chanty4u — Tue, 22 Mar 2016 13:20:23 GMT

am nt sure but chk below

how to convert sql query to qlikview load statement

Re: how to use SQL Query

Re: How can we write this SQL query in edit script

Digvijay_Singh — Tue, 22 Mar 2016 13:30:57 GMT

Not sure may be like this, tried to create pseudo script backward -

T1:

Load distinct mpn

from Manufacture

T2:

Load distinct lpn,mpn

from part_matching

Where exists (mpn);

T3:

Load *

From part_matching

Where exists(lpn)

Drop table T1,T2

Re: How can we write this SQL query in edit script

juleshartley — Tue, 22 Mar 2016 13:37:36 GMT

Or using joins:

Table1:

Load distinct mpn from Manufacturer;

inner join(Table1)

Load distinct mpn, lpn from xx_Part_Matching;

inner join (Table1)

Load lpn, field 1, field 2 etc.

from yy_Part_Matching;

Re: How can we write this SQL query in edit script

Anonymous — Tue, 22 Mar 2016 13:38:18 GMT

Why do you want to write this query in edit script? I would create a SQL View with this query and in Qlikview only select * from View.

Re: How can we write this SQL query in edit script

kkkumar82 — Tue, 22 Mar 2016 15:10:21 GMT

Thanks all,

I don't have a chance to create a view here, but I will try to create it. Just curious will the above two suggestions one with resident loads and another one with joins give the same result.

Thanks

Kiran Kumar

Re: How can we write this SQL query in edit script

petter — Tue, 22 Mar 2016 15:23:21 GMT

You don't need to create a view. You can use exactly the same SQL in the SQL part of the load script:

LOAD * ;

SQL

select * from xxxx_part_matching where lpn in (

select distinct lpn from yyyy_part_matching where mpn in (

select distinct mpn from manufacturer_part_number

)

);

This might be the fastest and most efficient solution for you. Since you will filter out unnecessary data at the earliest possible stage ...

Re: How can we write this SQL query in edit script

kkkumar82 — Tue, 22 Mar 2016 16:18:45 GMT

Hi Petter,

I observed that the both tables are from different databases , so, it is possible to do the same using the above query by putting the database names before the tables.

Hope you got my point.

Thanks

Kiran Kumar

Re: How can we write this SQL query in edit script

kkkumar82 — Tue, 22 Mar 2016 16:30:05 GMT

All,

I got the thing what I want, thanks petter I changed the query by including the database names before the tables .

Thanks

Kiran Kumar