topic Re: Update/Merge table in QlikView

Update/Merge table

nickedw0 — Tue, 17 Apr 2018 20:50:58 GMT

How can I add missing records to a table from a second table? I want to add records from 2nd table which do not exist in first table, while ignoring duplicates.

Re: Update/Merge table

nickedw0 — Tue, 17 Apr 2018 21:37:50 GMT

I figure I can use the Outer join.

Re: Update/Merge table

joseduque — Tue, 17 Apr 2018 21:46:12 GMT

Hi,

The outer keyword is optional and is the default join type used when a join prefix is not specified. So there is no need to put outer.

Hope this helps

Re: Update/Merge table

Digvijay_Singh — Tue, 17 Apr 2018 23:06:55 GMT

You may Concat 2nd table with Where not exists clause, before that you would need to create temp key field like this in first table -

Keyfield as tempkeyfield,

and then while loading 2nd table -

Where not exists(tempkeyfield,keyfield)