Skip to main content
  • EN

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

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

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


Community Stats

30,160
Posts
114,490
Replies
37,810
Members
Terms & ConditionsCookie 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.