Community Conundrum 28: News Engagement is live! Read More

Fold multiple columns

Level 2
Fold multiple columns

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

0 Kudos
2 Replies
Dataiker
Dataiker

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

Screenshot 2020-02-21 at 15.23.17.png

 

 

 

 

 

 

 

Hope this helps

0 Kudos
Level 2
Author

Thanks Vince

Guess this is the only way I can do this

0 Kudos