Using No Exists wit multiple fields

RC_121985 — Sat, 16 Nov 2024 19:44:40 GMT

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

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,

Re: Using No Exists wit multiple fields

Anil_Babu_Samineni — Wed, 06 Nov 2019 10:01:32 GMT

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

Re: Using No Exists wit multiple fields

venkat1 — Wed, 06 Nov 2019 10:02:41 GMT

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

Re: Using No Exists wit multiple fields

RC_121985 — Wed, 06 Nov 2019 12:03:51 GMT

@venkat1 Could you please provide me the Example.

topic Re: Using No Exists wit multiple fields in App Development

Using No Exists wit multiple fields

Re: Using No Exists wit multiple fields

Re: Using No Exists wit multiple fields

Re: Using No Exists wit multiple fields