Concatanate in prepared recipe
Options
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)
