Create a key from three different tables

[qlikwiz123]

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.

[qlikwiz123]

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]

Hi,

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

[canerkan]

Hi Qlikwiz123,

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

Regards Can

[qlikwiz123]

How do I do that?

[harithad95156 · Accepted solution]

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