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,019
Posts
114,001
Replies
37,640
Members
Terms & ConditionsCookie settings