Split recipe : Keeping null values

shahas71
shahas71 Dataiku DSS Core Designer, Registered Posts: 12

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

Answers

  • max
    max Dataiker Posts: 8 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
Setup Info
    Tags
      Help me…