topic Re: FROM SQL TO SCRIPT .... very difficult matter: in QlikView

FROM SQL TO SCRIPT .... very difficult matter:

Fri, 27 Jan 2012 09:34:47 GMT

I need to convert this sql query in a load script:

SELECT

CGANA00F.CONTCA AS C_DESTINATARIO_TEMP,

CGANA03F.ITSTAD AS C_PUNTO_VENDITA_TEMP

FROM CGANA00F

LEFT OUTER JOIN CGANA03F ON

CGANA00F.CDDTCA = CGANA03F.CDDTAD AND

CGANA00F.CONTCA = CGANA03F.CONTAD

WHERE

CGANA03F.ITSTAD <> ' '

here my try:

TAB_1:

LOAD CONTCA AS C_DESTINATARIO_TEMP,

CDDTCA AS key_J ;

//FROM [..\QVD_EME\CGANA00F.QVD] (qvd);

SELECT * FROM CGANA00F;

LEFT JOIN LOAD

CONTAD AS C_DESTINATARIO_TEMP,

ITSTAD AS C_PUNTO_VENDITA_TEMP,

CDDTAD AS key_J ;

SELECT * FROM CGANA03F

// FROM [..\QVD_EME\CGANA03F.QVD] (qvd)

WHERE ITSTAD <> ' ' ;

DROP FIELD key_J;

but it doesn't work ...

Can you help me?

FROM SQL TO SCRIPT .... very difficult matter:

kaushiknsolanki — Fri, 27 Jan 2012 09:43:16 GMT

HI,

Try this.

Data:
Load
CONTCA
Autonumber(CONTCA &'/'& CDDTCA) as Key

From CGANA00f.qvd

Left outer join

Load
ITSTAD
Autonumber(CONTCA &'/'& CDDTCA) as Key
From CGANA03f.qvd
Where ITSTAD <> ''

Regards,

Kaushik Solanki

FROM SQL TO SCRIPT .... very difficult matter:

Fri, 27 Jan 2012 10:07:01 GMT

i TRIED WITH THIS SCRIPT BUT IT DOESN'T WORK:

TAB_1:

LOAD CONTCA AS C_DESTINATARIO_TEMP,

AUTONUMBER(CDDTCA&'-'&CONTCA) AS CHIAVE_J ;

//FROM [..\QVD_EME\CGANA00F.QVD] (qvd);

SELECT * FROM CGANA00F;

JOIN LOAD

ITSTAD AS C_PUNTO_VENDITA_TEMP,

AUTONUMBER (CDDTAD&'-'&CONTAD) AS CHIAVE_J;

SELECT * FROM CGANA03F

// FROM [..\QVD_EME\CGANA03F.QVD] (qvd)

WHERE ITSTAD <> ' ' ;

DROP FIELD CHIAVE_J;

FROM SQL TO SCRIPT .... very difficult matter:

kaushiknsolanki — Fri, 27 Jan 2012 10:11:38 GMT

HI,

The script i said will work only if you will fetch data from qvd.

If you try to use the same for directly database it will not work.

Regards,

Kaushik Solanki

Re: FROM SQL TO SCRIPT .... very difficult matter:

Fri, 27 Jan 2012 10:13:04 GMT

I beg your pardon ... but why it doesn't work on sql and it works on qvd?

FROM SQL TO SCRIPT .... very difficult matter:

kaushiknsolanki — Fri, 27 Jan 2012 10:19:20 GMT

Hi,

Cause the script we wrote is specific to qlikview. The working of QlikView and Database is diff. Load statement is unknown for database.

Regards,

Kaushik Solanki

Re: FROM SQL TO SCRIPT .... very difficult matter:

Fri, 27 Jan 2012 10:28:24 GMT

I tried your solution with the qvd as well and with autonumber (obviosly I had to use just the left joint .... but i think it's the same of left outer join)

The problem is ... is still doens't work ....

The sql query and load script give me two different results ....

Re: FROM SQL TO SCRIPT .... very difficult matter:

Fri, 27 Jan 2012 10:29:29 GMT

Yes indeed before I have used the load of a select ...

FROM SQL TO SCRIPT .... very difficult matter:

kaushiknsolanki — Fri, 27 Jan 2012 10:34:25 GMT

Hi,

I would say if you can do the joining at database level, (meaning write sql with join to get the data.) do it there only. Cause QlikView might give you performance issue if the data is huge.

Regards,

Kaushik Solanki

Re: FROM SQL TO SCRIPT .... very difficult matter:

Fri, 27 Jan 2012 10:37:21 GMT

iF i CANNOT GET THE SAME RESULT WITH THE QLIKVIEW SCRIPT AS WITH THE SQL QUERY I MUST FOLLOW YOUR ADVICE .

THANKS FOR YOUR HELP!

FROM SQL TO SCRIPT .... very difficult matter:

kaushiknsolanki — Fri, 27 Jan 2012 10:38:41 GMT

HI,

My pleasure.

Regards,

Kaushik Solanki