Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on April 9, 2024 3:30PM
Likes: 0
Replies: 3
Hello everyone,
I have a prepare recipe and in the steps all my rows in columns are in the correct order. However, once the recipe runs, it is completely changing the order of how my rows need to be showing.
EX:
Last Name
First Name
ID
Last Name 1
First Name 1
ID 1
Last Name 2
First Name 2
ID 2
Once the recipe runs the order now shows as this:
ID
Last Name
First Name
Last Name 1
ID 1
First Name 1
Last Name 4
Last Name 2
ID 2
When I go back into the parent recipe it shows the rows correctly and I can't figure out how to stop this from happening once it is run. If anyone could please assist with this because it will mess up the who dataset and next recipe I need to do if it stays this way.
Update: Resolved
The prepared recipe has too many steps for it to process correctly, so I disabled my transform columns step and adding in fillers for blank rows, made a new prepared recipe with the transform column step and the order is now back intact as it should be.
If anyone has another solution without needing to make new prepare recipes, let me know.
Hi @ESoto
!
Maybe this could also help Re: Write recipe outputs (rows in initial order) - Dataiku Community?
-Konstantina
Hi @konathan
,
Thank you so much for your reply.
In this case, it looks like it is a recipe for SQL. However, in my case, these are datasets that were manually added in and store in Dataiku. Eventually, I want to utilize SQL but the initial framework of how the data looks is what I have been focusing on and due to company policy, I will need to get permission to connect to an SQL server.
However, let me know if the recipe the other user was using is relevant in this case.