Using No Exists wit multiple fields

[rvc_121985]

Hi All,

I have 2 Tables. 1 Open invoice table and 2. Cleared invoice table. I am looking to add both so that i get complete list of invoices. Challenge i am facing is Duplication of data in some cases due to Table refresh time.

Table1

LOAD
"Company Code",
"Supplier Code",
"Clearing date",
"Clearing Document",
"Assignment",
"Fiscal Year",
"Doc Number",
"Posting Date",
"Document Date",
"Entry Date",
"Currency",
"Reference",
"Document Type",
"Posting Period" ,
"D/C indic",
"Amount in LC",
"Text",
"G/L Account",
'Cleared' as "Current Status"

Concatenate

 LOAD
"Company Code",
"Supplier Code",
"Clearing date",
"Clearing Document",
"Assignment",
"Fiscal Year",
"Doc Number",
"Posting Date",
"Document Date",
"Entry Date",
"Currency",
"Reference",
"Document Type",
"Posting Period" ,
"D/C indic",
"Amount in LC",
"Text",
"G/L Account",
'Open' as "Current Status"

All the fields are same in both the table but Clearing Date and Clearing Document gets updated in Cleared table.If these 2 fields are blank that means the invoice is still open.

If there is any duplicates i need the line from Table 1 (Cleared table) and nether from table 2 nor duplicate.

How do i achieve it using "Where No Exist" ?

Unique field can be generated using  "Company Code", "Supplier Code","Fiscal Year","Doc Number","D/C indic" and
"Amount in LC",

Thanks,

[Anil_Babu_Samineni]

Check if that helps https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

[venkat1]

i think,you can try with qualify and un qualify,right?

[rvc_121985]

@venkat1 Could you please provide me the Example.