Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
benwashburne
Partner - Creator
Partner - Creator

Applymap for Null values after Qlik join

stalwar1johnwcri

Hello to the above and anyone that can help!

I am trying to map null orphan values to a default value of 0 after an outer join has occurred. Is this possible?

Here is the code:

[Tracker]:

LOAD

    "MIA CASE SEQ" as [MIA CASE SEQ-MIA_CASE_SEQ],

    MT,

    Y,

    AU,

  

FROM mysource

[Other table]:

Load

"MIA_CASE_SEQ" as [MIA CASE SEQ-MIA_CASE_SEQ],

FIELD1

FIELD2

FIELD3

From qvd.source

**Now, how do I go about applying a map to this outerjoined table?  I need to make sure that all the in all the instances that there was not a join on the [MIA CASE SEQ-MIA_CASE_SEQ] that the corresponding orphan nulls for AU, MT, and Y = 0. **


Any thoughts/comments would be much appreciated.


Thanks,

Ben

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You can do it with another resident load and this mapping approach showed in

Filling Default Values Using Mapping | Qlikview Cookbook

View solution in original post

3 Replies
marcus_sommer

swuehl
MVP
MVP

You can do it with another resident load and this mapping approach showed in

Filling Default Values Using Mapping | Qlikview Cookbook

benwashburne
Partner - Creator
Partner - Creator
Author

Stefan,

Perfect! I had seen that solution mentioned in another post but it did not have the resident load statement included.

Thanks,

Ben