topic Re: LEFT KEEP on three tables in QlikView

LEFT KEEP on three tables

Black_Hole — Sat, 16 Nov 2024 20:33:03 GMT

Hello all,

I have 3 tables and two primary keys.

Please could you tell me how I can use the left keep function in the context below?

Table_1: CustomerID as key_1, name, address

Table_2: ID as key_1, ISO, label, quantity

Table_3: ISO, country, detail_address

Thank you in advance for your help.

marcus_sommer — Mon, 01 Jul 2019 13:52:21 GMT

Pure technically it would be:

Table_1: load CustomerID as key_1, name, address from a;

Table_2: left keep load ID as key_1, ISO, label, quantity from b;

Table_3: left keep load ISO, country, detail_address from c;

But it couldn't be said if it's really suitable to your data and datamodel.

- Marcus