How to avoid values from being overwriting with nulls
Article ID: KB0078384
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | V1 |
Description
Product: TIBCO Scribe® Online
Issue: Target data is being over written with NULL values in TIBCO Scribe® Online
Issue: Target data is being over written with NULL values in TIBCO Scribe® Online
Issue/Introduction
Workaround to prevent target data from being overwritten with NULL values in TIBCO Scribe® Online
Resolution
TIBCO Scribe® Online defaults to overwriting target data with NULL values. So essentially, without a formula on the linked field, the TIBCO Scribe® Online core does not interfere with NULL values being passed across during processing. It passes them right to the target connector. Standard design in Scribe connectors is to pass the NULL to the target API call without making any changes.
To get the opposite behavior in Scribe Online, to avoid overwriting the target with NULLS, requires the implementation of some block logic in the map (e.g. using the IF Block).
To get the opposite behavior in Scribe Online, to avoid overwriting the target with NULLS, requires the implementation of some block logic in the map (e.g. using the IF Block).
Feedback
Yes
No
Powered by
