Data Association - Keep uncommon data

[abonnery]

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 !

[JuanGerardo]

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