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