Inner join not working in Incremental loading

[dseelam]

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)

[rubenmarin]

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?

[dseelam]

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

[rubenmarin]

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.