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