Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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 |
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)