topic Re: join tables where 2 fields correspond in QlikView

join tables where 2 fields correspond

ranibosch — Wed, 03 Oct 2018 06:39:25 GMT

Good day,

i have the following 2 tables:

i want to joint the expiration date to the item ledger entries table.

so basically where the item no + document number is the same in both tables, then bring in the expiration date into the item ledger entries table.

i hope someone can assist with this!

Re: join tables where 2 fields correspond

tresB — Wed, 03 Oct 2018 06:42:59 GMT

You can move ahead with this existing model (with synthetic keys - as being shown in your model screen shot; please remember synthetic keys are NOT bad if they are not incorrectly modeled). Or, you could create a composite key to associate the fields.

Re: join tables where 2 fields correspond

niclaz79 — Wed, 03 Oct 2018 07:11:12 GMT

Hi,

That's a very simple join to make.

left join(ITEM LEDGDER ENTRIES)

LOAD

[Item no],

[Document no],

[Expiration Date]

Resident [Ambassador Packing List];

drop table [Ambassador Packing List];