topic Re: Key from two different tables in QlikView

Key from two different tables

MatsiG — Mon, 26 Jan 2026 16:26:21 GMT

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?

Re: Key from two different tables

marcus_sommer — Tue, 27 Apr 2021 08:26:13 GMT

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