Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

Is there a setting that needs to be changed to allow Zero's to loaded?

Originally posted by Craig Masters

4/5/2018

Is there a setting that needs to be changed to allow Zero's to loaded? When I load a file with zeros, those lines are stripped out in the staging table. I need to merge a file with zeros to replace the amounts currently in the system.

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    Originally posted by Puja Patel

    Yup - On the Data Sources page, click on the specific data source you want to load zeros for. Then click on the 'Amount' source dimension. Under the Numeric Settings section, change 'Zero Suppression' to False. That will allow you to load zeros in through import.