Qlik Community

App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
abonnery
Contributor III
Contributor III

Data Association - Keep uncommon data

Hello, 

 

I was wondering when you are associating data through the data load editor: is there a way to keep the data that is not in the 2 associated fields. 

For example: if I want to associate 

Site_Client: 

A, 

B, 

C, 

E

and Site_Customer : 

A,

B, 

C,

D

I will rename those 2 with the same field name (Site for example), but how can I make sure to still see D and E in the loaded data of the Site field ?

 

Thank you for your help !

1 Reply
JuanGerardo
Partner
Partner

Hi @abonnery, you will get both values in the final application as are part of the same field (in Qlik Sense this is not like in a relational DB, and this is not a standard join, think of it more like an outer join). And you don't have to do anything special apart from rename the fields, this is the standard behavior.

So you will get D and E, but if you select E, all values from Site_Customer table will be nulls as they have no correspondence. In the same way, if you select D, you won't see values from Site_Client table fields.

JG