Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatente 2 tables but only keep

I want to concatenate 2 tables, but tddockla_docnr is not unique. So I only want to keep values from the second table if tddockla_docnr from the second table NOT matches tddockla_docnr from the first table.

Code:

TurnoverDocnrMatch:   //Invoices

Load

tddockla_docnr,

vereffenddocnr,

tddockla_docsoort,

if(Exists(tddockla_docnr, tddockla_docnr), 1 , 0)

resident TurnoverDocnrRCT;

 

Concatenate

TurnoverDocnrMatch1:  //Credit notes

Load

tddockla_docnr,

vereffenddocnr,

tddockla_docsoort

resident TurnoverDocnrCRN;

//i think a where clause will be needed here ...

And later the TurnoverDocnrMatch table is stored in a .txt file and the table is dropped.

Is there an easy way to accomplish this? Match or Exists maybe?

Thanks!

0 Replies