Joining two values as one

[#1]

Hi,

I need a help on a data load in Qlik Sense Desktop.

I have two data tables which I need to connect by two values Transaction type and Document ID so that I might analyse data in a Qlic Sense. there is no other way bacause only these two vales identyfing records between those tables.

Is there any way on a data load to do that?

Thanks in advance.

Vidas Rojus

[MK_QSL]

Create a Join Key as

[Transaction Type]&' | '&[Docuemnt ID] as Key

in both table table and Comment on these two fields in any one table

[Anonymous]

Hi Vidas,

Simple join will do the work:

Table2:

load

    *

from

Table2Source.qvd

(qvd);

left join (Table2)

load

     *

from

Table1Source.qvd

(qvd);

Qlik engine joins information based on the fields' names so it will recognise key fields automatically.

Best regards,

Janusz

[saumyashah90 · Accepted solution]

In Script:

Load

[Transaction Type]&' - '&[Docuemnt ID] as Composite_Key

[Josh_Good]

Hi Vidas,

Strictly speaking you can just load the two tables you described above and Qlik Sense will take care of creating a 'synthetic key' to join the tables correctly.  Often users will manually create a composite key to eliminate the synthetic key as described by Saumya and Manish in order to keep the data model clean and efficient.

-Josh

Qlik