Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@somersst, the answer is you need to write manually, I do not think the easy way.