How to Load Zeros Through Data Load Rules to Reflect in a Template

1 Minute to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Loading zeros through the Data Load Rules will not reflect 0 in the template. If you want data in a template to display as a zero (0) versus a dash (-) in a template, load 0.000001 (1 as sixth decimal) versus 0 via Data Load Rules. The Data Load Rule will indicate data was successfully loaded and the values will be shown when the template is opened.

Note:

This functionality behaves as it does because 'zero' is not recognized as a value.

The values is a template can be zeroed manually as well.

Was this article helpful?

What's Next

Auditing Data Integration