The February release for the Community is live! Read More

Fold multiple columns

Solved!
bhakuniv
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
1 Solution
VinceDS
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

View solution in original post

0 Kudos
2 Replies
VinceDS
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

View solution in original post

0 Kudos
bhakuniv
Level 2
Author

Thanks Vince

Guess this is the only way I can do this

0 Kudos