-
Re: Zero Values exporting to CSV
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
Janet Grimsley Dec 27, 2017 1:11 PM (in response to Stephen Smay)Stephen, I am using 13.5 Complete. I did use a new formula that solved the problem. I was trying not to create a formula, thinking Monarch would export as I was seeing it on the screen.
-
-
Re: Zero Values exporting to CSV
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
-
Re: Zero Values exporting to CSV
Janet Grimsley Dec 27, 2017 1:14 PM (in response to Grant Perkins)When I converted to character the zero presented as a blank, but still exported the zero. Weird behavior, but a formula solved the problem. I created a new column,
If(F25 = "0","", F25)
-