Replace function not working properly in Prepare recipe

Dataiker, Alpha Tester Posts: 535 Dataiker
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?

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Dataiker, Dataiku DSS Core Designer, Registered, Moderator Posts: 753 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.
  • Neuron 2020, Neuron, Registered, Neuron 2021, Neuron 2022, Neuron 2023 Posts: 90 Neuron

    Are there any updates on this or work arounds?

  • Registered Posts: 27 ✭✭✭✭

    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')

  • Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭

    @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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.