Skip to main content
Solved

NullAttributeMapper...

  • November 3, 2020
  • 2 replies
  • 43 views
simonhume
Contributor
Forum|alt.badge.img+2

Hi

I'm hoping someone can help me with a query.

I have a SQL Server view that i am opening in FME; this contains both commercial and residential addresses

 

The view has 2 reference columns, one contains a Council Tax reference, the other a Business Rates reference

 

Some of the residential records do not have a Council Tax reference as they are not live properties; the reference column is NULL for these

 

I have used a NullAttributeMapper to change the NULL value to New Build, but all records with a NULL value are being changed, including the Commercial records

 

Is there a way of using the NullAttributeMapper to query 2 columns in the table so only NULL records that are residential. Or is there another transformer that would be more suitable?

thanks

Simon

Capture

Best answer by ebygomm

Instead of the NullAttributeMapper you can use an AttributeCreator or AttributeManager with a conditional query e.g. if Type = Residential and CTax is null, set value to 'New Build'

Capture

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • ebygommInfluencer
  • Influencer
  • Best Answer
  • November 3, 2020

Instead of the NullAttributeMapper you can use an AttributeCreator or AttributeManager with a conditional query e.g. if Type = Residential and CTax is null, set value to 'New Build'

Capture

simonhume
Contributor
Forum|alt.badge.img+2
  • simonhumeContributor
  • Author
  • Contributor
  • November 18, 2020

Instead of the NullAttributeMapper you can use an AttributeCreator or AttributeManager with a conditional query e.g. if Type = Residential and CTax is null, set value to 'New Build'

Capture

@ebygomm​ 

sorry for the delay in replying. Your advice has worked thank-you

 

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.