4 Replies Latest reply: Dec 27, 2017 1:14 PM by Janet Grimsley RSS

    Zero Values exporting to CSV

    Janet Grimsley
    Janet Grimsley Nov 13, 2017 9:15 AM

      I am using Monarch 13.5 and bringing in a txt file and exporting as a csv file.  I have a field that contains zero values.  I need the field to show as a blank in the exported csv file, if it is a zero value.  In Monarch, I can suppress the zero value, but it still exports as a zero. 

       

      Janet Grimsley

      • 695 Views
      • Tags:
        • Re: Zero Values exporting to CSV
          Stephen Smay
          Stephen Smay Nov 13, 2017 1:25 PM (in response to Janet Grimsley)

          Hey Janet, are you talking about Monarch Classic, or Data Prep Studio?

           

          In either case, I think you will need to create a formula field that will result in a null if the value is 0.

           

          One formula to accomplish this is [Column] / [Column] * [Column]

          • Re: Zero Values exporting to CSV
            Grant Perkins
            Grant Perkins Nov 14, 2017 4:58 AM (in response to Janet Grimsley)

            Janet,

             

            What is the target application for the exported CSV file?

             

            If the exported column is going to be interpreted as numeric when imported to the target application what will that application do with blanks or specific NULL outputs?

             

            Or to look at is another way - an alternative approach to consider is, like Stephen's suggestion, to create a calculated field and export that instead of the "real" field but just make the field Character. That way if it present in Monarch as blank I would expect it to be exported as blank. However the target application may do something else with it when assessing it for ingestion. Hence the question.

             

            Grant