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

KK2012's avatar
KK2012
New Contributor III
1 year ago
Solved

How to treat blank values for Source field and wanted to assign it to 'None' Target member

Hi Team, My validation step failed because the source mapping is missing for blank records. I attempted to add a mapping with (blank) for the source value and None for the target value, but it didn’...
Transformation
ZubairCSC's avatar
ZubairCSC
New Contributor II
7 months ago

KK2022 can you please share the code of complex expression?

TTT's avatar
TTT
New Contributor
24 days ago

Something like this will work:

Return If(String.IsNullOrEmpty(args.Value), "None", args.Value)