Applymap Nulls

[kevbrown]

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]

Hi,

Please try below conditon

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

[sunny_talwar · Accepted solution]

This should also work:

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

[kevbrown]

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