Concatanate in prepared recipe

Elise_Viot

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

Katie

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

Hi @ktgross15
,

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