Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ranibosch
Creator
Creator

join tables where 2 fields correspond

Good day,

i have the following 2 tables:

Capture.JPG

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!

2 Replies
tresesco
MVP
MVP

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.

niclaz79
Partner
Partner

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];