Concatanate in prepared recipe

Elise_Viot
Level 1
Concatanate in prepared recipe

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
 

 

 

 

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

0 Kudos
Elise_Viot
Level 1
Author

Hi @ktgross15

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

 

0 Kudos

Labels

?
Labels (1)

Setup info

?
Tags (1)
A banner prompting to get Dataiku