Applymap for Null values after Qlik join

[benwashburne]

stalwar1‌ johnw‌ cri‌

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

[marcus_sommer]

See: Re: Orphan Records in Qliksense

- Marcus

[swuehl · Accepted solution]

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

Filling Default Values Using Mapping | Qlikview Cookbook

[benwashburne]

Stefan,

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

Thanks,

Ben