Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Fold multiple columns
Added on February 21, 2020 2:08PM
Likes: 0
Replies: 2
bhakuniv
Registered Posts: 9 ✭✭✭✭
Hi
I am using fold multiple columns in my prepare recipe, the output in not preserving empty values. Is there any way to ensure that the empty values are preserved.
The DSS documentation says the empty values will be preserved but I am not seeing that in the result
Thanks
VB
Best Answer
-
Hi,
Indeed, I've been trying to reproduce and it seems empty values are not taken into account.
A possible workaround is to:
a) Fill empty values in multiple columns (with 'N/A') for instance
b) Fold multiple
c) Find and replace 'N/A' with empty values
Hope this helps
Answers
-
Thanks Vince
Guess this is the only way I can do this