The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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...
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