topic Re: Inner join not working in Incremental loading in QlikView

Inner join not working in Incremental loading

dseelam — Thu, 03 Nov 2016 15:23:13 GMT

Hello guys new to incremental

all my code is in attachment below once I reload with inner join which should delete the records

it is duplicating the data (assuming ntg is deleted records should be 183,754)

Re: Inner join not working in Incremental loading

rubenmarin — Thu, 03 Nov 2016 15:45:07 GMT

Hi Dinesh, in the code attached the inner join is commented.

I supposse this is not the issue and you commented on purpose... have you checked that the last laoded values really have a different %CUST_PO? Some value loaded in incremental table wich doesn't exists in the inner join query results?

Re: Inner join not working in Incremental loading

dseelam — Thu, 03 Nov 2016 17:38:13 GMT

Hello Ruben,

It was commented on Purpose, Yes there is a max value which is diff %CUSTPO

issue is if I un comment that inner join results are very higher num then expected

Re: Inner join not working in Incremental loading

rubenmarin — Fri, 04 Nov 2016 11:37:59 GMT

Hi Dinesh, you have to check the data to find any value wich doesn't have to be there, you can try adding a field in the inner join:

Inner join

LOAD

"CUST_PO_NUMBER" as %CUST_PO,

'1' as Found;

SQL SELECT *

FROM XXHHF."XXHSP_DB_CANCELLED_LINES_V";

Create a new document with the data of the qvd generated in the next store to check if there is any value for %CUST_PO which doesn't have the field 'Found' with the value '1'.

If every row has that value the inner join is working correctly and the issue is caused by other thing.