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

EmilieDurand's avatar
EmilieDurand
New Contributor II
2 years ago

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 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

Transformation

4 Replies

  • Henning's avatar
    Henning
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    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.

  • CarlosAlvear's avatar
    CarlosAlvear
    Contributor II
    2 years ago

    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

  • Richard_Mayo's avatar
    Richard_Mayo
    New Contributor III
    2 years ago

    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