Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

Replace function not working properly in Prepare recipe

Replace function not working properly in Prepare recipe
Hi All,

What I am trying to do is replace empty cells with '0'. After running the recipe, only a few rows are getting replaced with 0 and others remain blank.

Please note that this is only happening when I select Spark engine. Other engines do not cause this problem. Is this a known problem with spark engine in prepare recipe?
0 Kudos
4 Replies

We confirm this as a known issue when using "All" or "Pattern" columns selection mode in Spark engine: filling of value will only start after the first non-empty value. We are working on this.
0 Kudos

Are there any updates on this or work arounds?

0 Kudos
Level 3

All - is there any workarounds? I tried running it in both local stream and spark, and it didnt work (i.e. only a few rows were replaced with '0')

0 Kudos
Dataiker Alumni

@adamnieto @GSung Thank you for following up. We can confirm that there are no updates or any recommended workarounds at this point. We are still working on this and will take your questions and feedback into consideration.  

Looking for more resources to help you use Dataiku effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!