Key from two different tables

[MatsiG]

Hi guys, 

I have a Problem with my Data Model - I am trying to create a Key over two different tables. 

First Table:
Load
dimension1,
dimension2;
SQL SELECT *
FROM xyz;

Second Table:
Load
dimension 1,
dimension 3;
SQL SELECT *
FROM abc;

I want to create a key from both tables: Dimension1&'_'&Dimension3. Can someone help me?

[marcus_sommer]

Maybe in this way:

[Second Table]:
mapping Load
dimension 1,
dimension 3;
SQL SELECT *
FROM abc;

[First Table]:
Load
dimension1,
dimension2,
applymap('Second Table, dimension1, '#NV') as dimension3
dimension1 &'|' & applymap('Second Table, dimension1, '#NV') as KEY;
SQL SELECT *
FROM xyz;

- Marcus