Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Do not send Null values to Target connector in Scribe Online


Recommended Posts

Hi @Murali Anand,

 

You can achieve this in Scribe Online with:

 

Lookup Block for the target entity

This formula in the destination field in the Update block

 

IF ( ISNULLOREMPTY (SourceEntity.field) , Taget_LookupEntity.field , SourceEntity.field)

 

 

 

 

So you need to first lookup the existing record. If the source is null, write back the existing value to the field, otherwise, write the new value.

 

Keep in mind this method will reduce performance and increase API hits for the target, as each record will require an additional lookup.

 

There is a feature on the Scribe Online road map to perform this function without an API call and make it easier through the UI. I don't have an estimate of when it will be released.

 

Let us know what else you need.

 

Jeff

Link to comment
Share on other sites

  • 2 weeks later...
  • 5 weeks later...
  • 1 year later...
×
×
  • Create New...