Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Two tables into 1 field (which is in a different table)?

Hello!

Can someone help me figuring our the following? I'm trying to combine 3 tables into one:

Table 1 [forms] Contains:

     - LeadId

     - ContactId

Table 2 [contacts] Contains:

     - ContactId

     - Name

Table 3 [leads] Contains:

     - LeadId

     - Name

I want the field 'Name' of table 2 and table 3 to be put into table 1 based on the lead/ContactId where ContactId is more important then LeadId (so if both LeadId and ContactId contain data, the name of the table Contact is taken). So what I finally want:

Table [forms]

     - LeadId

     - ContactId

     - Name

I have tried to achieve this with left join but this only joins one of the 2 into the field Name, if I rename one of the two to Name1 both are displayed.

Thanks in advance

2 Replies
MVP
MVP

Re: Two tables into 1 field (which is in a different table)?

What if you do simple joins instead of left join?

Table1:

LOAD LeadId,

          ContactId

FROM ...;


Join (Table1)

LOAD ContactId,

          Name

FROM ....;

Join (Table1)

LOAD LeadId,

          Name

FROM ....;

Not applicable

Re: Two tables into 1 field (which is in a different table)?

I also tried a simple join, still the same result. Only 1 of the 2 tables is joined into table 1 (the one which is on top).