Concatanate in prepared recipe

Elise_Viot
Elise_Viot Dataiku DSS Core Designer, Registered Posts: 2 ✭

Hello,

it seems like the concatenate function from the prepared recipe doesn't work when one of the element is missing.


Example :

Col1Col2concatenated column
HPPCDHPP CD
WAP when col 2 is empty the concatenated column is also empty

Tagged:

Answers

  • Katie
    Katie Dataiker, Registered, Product Ideas Manager Posts: 110 Dataiker

    hi @Elise_Viot

    can you please share more detail on the exact steps you are adding & what your dataset looks like? i tested with blank cells on my end and it seemed to work correctly.

    katie

  • Elise_Viot
    Elise_Viot Dataiku DSS Core Designer, Registered Posts: 2 ✭

    Hi @ktgross15
    ,

    I forgot to mention that the engine is in-database sql (our data are stocked in redshift aws)

Setup Info
    Tags
      Help me…