Fold multiple columns

bhakuniv
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

  • VinceDS
    VinceDS Dataiker, Alpha Tester, Dataiku DSS Core Designer Posts: 45 Dataiker
    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

    Screenshot 2020-02-21 at 15.23.17.png

    Hope this helps

Answers

Setup Info
    Tags
      Help me…