Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

Replace function not working properly in Prepare recipe

UserBird
Dataiker
Dataiker
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
Clément_Stenac
Dataiker
Dataiker
Hi,

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
adamnieto
Neuron
Neuron

Are there any updates on this or work arounds?

0 Kudos
GSung
Level 2

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
CoreyS
Community Manager
Community Manager

@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!
Labels (3)
A banner prompting to get Dataiku DSS