topic Re: Applymap Nulls in QlikView

Applymap Nulls

kevbrown — Wed, 08 Feb 2017 11:11:00 GMT

Hi,

I have a table that has some nulls in it that I'd like to map another table to, to fill in the nulls.

So I have a mapping table called OfficeName with the fields Office Key and Office Name.

The field I want to map this to is called Office Name, but only where the nulls are.

APPLYMAP (‘OfficeName’,if(IsNull([Office Name]), [OfficeName]) AS [Office Name],

Is that anywhere close to where I need to be?

Thanks

khalander — Wed, 08 Feb 2017 11:19:35 GMT

Hi,

Please try below conditon

if(IsNull([Office Name]),ApplyMap(‘Office_Name’, office_key),[Office Name]) as [Office Name]

sunny_talwar — Wed, 08 Feb 2017 11:57:23 GMT

This should also work:

ApplyMap('OfficeName', If(IsNull([Office Name]), [Office Key]), [Office Name]) AS [Office Name],

kevbrown — Wed, 08 Feb 2017 12:43:49 GMT

Superb, thank you. Knew I wasn't far off