Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
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
MVP & Luminary
MVP & Luminary

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