Transformation Rule Mapping Null
Hi,
I am trying to load a CSV file to OneStream through my Workflow. I have a few rows in my csv file where the IC column is empty. I am trying to map those IC lines to go in "None". How would you...
Forum Discussion
Hi Emilie,
We don't use CSV for uploads but instead we use Excel files with an XF named range so not certain this would work for you but maybe worth investigating?
We put a reference to a parser rule at the top of the XF range which applies some logic similar to what you were asking about (it turns a blank entry into "None"). In this case it is working on the Flow dimension but could work on IC equally I would have thought.
I'll attach a screenshot in case you want to investigate this.
Regards,
Richard