Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
somersst
Contributor III
Contributor III

Best practice to join data from 2 sources

Hi,

 

I start from source A for example customer. (for example 100 customers)

 

Now I have 2 sources B & C that can have address-info for this customer. (they don't have necessary info for these 100 customers)

 

I created 2 maps :

I do a lookup to  address-info in source B. (outer join)

 

Next I do a lookup in source C. (outer join)

 

Now when the second lookup in Source C doesn't have a value, it still needs to use the value of source B. 

When you make use of an outer join and you map the address info of source C and it doesn't have a value, you unfortunateley get a null value. I know you can make use of a formula to check if null, but if it's about a lot of fields this is considerable work. So I was wondering if there was an easier way.

 

 

Labels (2)
1 Reply
manodwhb
Champion II
Champion II

@somersst, the answer is you need to write manually, I do not think the easy way.