topic Re: How to join two qvd in QlikView

How to join two qvd

Wed, 07 Aug 2013 05:53:49 GMT

I have two qvds like following:

tQals:

LOAD WERKS_QALS, BUDAT_QALS, AUFNR_QALS, PRUEFLOS_QALS, BWART_QALS, STAT19_QALS, MATNR_QALS, LMENGE01, LMENGE02, LMENGE04, CHARG_QALS, DCM

FROM [$(vSaveQVD)tQals.qvd] (qvd);

tAufk:

LOAD AUFNR_AUFK
FROM [$(vSaveQVD)tAufk.qvd] (qvd);

I would like to get all data from tQals where AUFNR_QALS not exists in tAufk->AUFNR_AUFK.

Please help.

Re: How to join two qvd

tresB — Wed, 07 Aug 2013 06:07:23 GMT

Try this:

tAufk:

LOAD AUFNR_AUFK as AUFNR_QALS

FROM [$(vSaveQVD)tAufk.qvd] (qvd);

tQals:

LOAD WERKS_QALS, BUDAT_QALS, AUFNR_QALS, PRUEFLOS_QALS, BWART_QALS, STAT19_QALS, MATNR_QALS, LMENGE01, LMENGE02, LMENGE04, CHARG_QALS, DCM

FROM [$(vSaveQVD)tQals.qvd] (qvd) Where Not Exists (AUFNR_QALS);

Drop Table tAufk;

Re: How to join two qvd

jagan — Wed, 07 Aug 2013 06:10:15 GMT

Hi,

Use Not Exists option in the second load statement.

Hope this helps you.

Regards,

Jagan.

Re: How to join two qvd

somenathroy — Wed, 07 Aug 2013 06:10:59 GMT

Hi,

Look at the below code:

tAufk:

LOAD AUFNR_AUFK
FROM [$(vSaveQVD)tAufk.qvd] (qvd);

tQals:

Load *

FROM [$(vSaveQVD)tQals.qvd] (qvd)

Where not Exists (AUFNR_AUFK , AUFNR_QALS);

Regards,

som

Re: How to join two qvd

Wed, 07 Aug 2013 06:14:51 GMT

try to use according to this format

tAufk:

LOAD AUFNR_AUFK as AUFNR_QALS
FROM [$(vSaveQVD)tAufk.qvd] (qvd) ;

tQals:

LOAD WERKS_QALS, BUDAT_QALS, AUFNR_QALS, PRUEFLOS_QALS, BWART_QALS, STAT19_QALS, MATNR_QALS, LMENGE01, LMENGE02, LMENGE04, CHARG_QALS, DCM

FROM [$(vSaveQVD)tQals.qvd] (qvd);

Right Join

tAufknew:

LOAD AUFNR_QALS
resident tAufk Where not Exists(AUFNR_QALS);

Re: How to join two qvd

Wed, 07 Aug 2013 06:50:11 GMT

try this

hi modakindia

According to your question i tried then find the right solution, so try this below code

tAufk:

LOAD AUFNR_AUFK as AUFNR_QALS
FROM [$(vSaveQVD)tAufk.qvd] (qvd) ;

Right Join

tQals:

LOAD WERKS_QALS, BUDAT_QALS, AUFNR_QALS, PRUEFLOS_QALS, BWART_QALS, STAT19_QALS, MATNR_QALS, LMENGE01, LMENGE02, LMENGE04, CHARG_QALS, DCM

FROM [$(vSaveQVD)tQals.qvd] (qvd) Where not Exists(AUFNR_QALS);

Regards

Re: How to join two qvd

Wed, 07 Aug 2013 08:12:14 GMT

Thanks for your reply.

Pleas help at the following:

LET vTableName = 'tTemp1';

tTemp1:

LOAD WERKS_QALS, BUDAT_QALS, AUFNR_QALS, PRUEFLOS_QALS, BWART_QALS, STAT19_QALS, MATNR_QALS, LMENGE01, LMENGE02, LMENGE04, CHARG_QALS, DCM

FROM [$(vSaveQVD)tQals.qvd] (qvd) Where not Exists(AUFNR_QALS);

IF ScriptErrorCount = 0 then

STORE $(vTableName) into [$(vSaveQVD)$(vTableName).qvd] (qvd);

ENDIF