topic Re: Create a key from three different tables in App Development

Create a key from three different tables

qlikwiz123 — Tue, 30 Nov 2021 18:17:33 GMT

I have three tables

TableA:

Location,

Country

TableB:

Division

Branch

Final:

ID,

Country,

Division

I need to create a key in 'Final' table with Autonumberhash(Location&Branch&ID)

How do I do this since other two fields are in different tables.

harithad95156 — Wed, 26 May 2021 13:06:19 GMT

Hi,

You can use Apply Map function to get those 2 fields by applying mapping
load for the first 2 tables.

canerkan — Wed, 26 May 2021 13:08:40 GMT

Hi Qlikwiz123,

did you try joining those tables? That way you would not need to create a key

Regards Can

qlikwiz123 — Wed, 26 May 2021 14:21:14 GMT

How do I do that?

harithad95156 — Thu, 27 May 2021 09:50:42 GMT

Hi,

Mapping Load TableA:

Location,

Country

MappingLoad TableB:

Division,

Branch

Final:

ID,

Applymap('TableA', country,optional vslue) as Location,

Applymap('TableB', Division, optional value) as Branch,

Country,

Division

For creating the key use:

Autonumber('Location'&'Branch'&'ID', composite key) as composite key