Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Joining two values as one

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

1 Solution

Accepted Solutions
saumyashah90
Valued Contributor

Re: Joining two values as one

In Script:

Load

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

4 Replies
MVP
MVP

Re: Joining two values as one

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

janusz_twardzia
Contributor

Re: Joining two values as one

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
Valued Contributor

Re: Joining two values as one

In Script:

Load

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

Employee
Employee

Re: Joining two values as one

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