Data Association - Keep uncommon data

abonnery — Wed, 16 Jun 2021 08:53:50 GMT

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:

and Site_Customer :

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 !

Re: Data Association - Keep uncommon data

JuanGerardo — Wed, 16 Jun 2021 10:49:16 GMT

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.

topic Data Association - Keep uncommon data in App Development

Data Association - Keep uncommon data

Re: Data Association - Keep uncommon data