Skip to main content
Newcomer
Oct 28, 2024 2:49 AM UTC
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’t work. How should blank source values be handled in the mapping? Can you please help me with this if anyone face similar issue ? Thank you

KK2012_0-1730083667103.png

 

 

Contributor
Oct 28, 2024 3:08 AM UTC

4 replies

Contributor
Oct 28, 2024 3:08 AM UTC
KK2012Author
Newcomer
Oct 30, 2024 11:32 AM UTC

Thank you. I have used complex expression in Data source which resolved the issue. 

Newcomer
Oct 23, 2025 4:21 PM UTC

KK2022 can you please share the code of complex expression?

Member
Jun 2, 2026 3:58 PM UTC

Something like this will work:

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