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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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.