Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi Qlikwiz123,
did you try joining those tables? That way you would not need to create a key
Regards Can
How do I do that?
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