Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

Split recipe : Keeping null values

shahas71
Level 2
Split recipe : Keeping null values

Hi All,

Consider this as my input :

AccountValue
A 
B1,2
C3,4


& i want the output as:

AccountValue
A 
B1
B2
C3
C4

 

But what i'm getting is this :

AccountValue
B1
B2
C3
C4


The null value cell is getting removed. 

Anybody can provide with solution?

Thanks in advance


Operating system used: windows

0 Kudos
1 Reply
max
Dataiker
Hello @shahas71,

One workaround to this is to first use a replace processor to replace the empty cells with an unique arbitrary value (e.g., "REPLACE_THIS"), then run the split and fold processor (which should still preserve the cells with "REPLACE_THIS"), then add another replace processor to replace "REPLACE_THIS" with null again.

Another potential solution is to use the tokenize processor with "One token per row" selected under "Operation", but this will depend on what your actual data looks like.

Hope this helps,

Max
0 Kudos