Transformation Rule Mapping Null

[EmilieDurand]

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 do this? I have tried through a one-to-one mapping; source: |null| and target: None, but it doesn't seem to be working.

Thank you

[Richard_Mayo]

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

[Richard_Mayo]

[CarlosAlvear]

Hi Emilie,

You can add a fixed text before/after the reading of that column. For instance, if you add a "IC__" before, you can add a rule stating that if you read a "IC__" is equivalent to a "None".

Best regards,

Carlos

[Henning]

Hi, another approach is to create a complex expression or rule in the Data Source you are using to upload your file and replace the empty string with "None" (or a random placeholder such as "empty" that you then need to map) in there.