Concatanate in prepared recipe
![Elise_Viot](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar1.png)
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 :
Col1 | Col2 | concatenated column |
HPP | CD | HPP CD |
WAP | when col 2 is empty the concatenated column is also empty |
Tagged:
Answers
-
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
-
Hi @ktgross15
,I forgot to mention that the engine is in-database sql (our data are stocked in redshift aws)