Skip to main content
Solved

NullAttributeMapper...

simonhume
Participant
Forum|alt.badge.img+1

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

View original
Did this help you find an answer to your question?

2 replies

ebygomm
Influencer
Forum|alt.badge.img+31
  • 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
Participant
Forum|alt.badge.img+1
  • simonhumeParticipant
  • Author
  • Participant
  • November 18, 2020
ebygomm wrote:

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

 

Reply


Helpful Members This Week

Community Stats

30,980
Posts
117,401
Replies
38,762
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.