Problem in windows recipe tutorial
I am doing windows recipe after join, prepare and group recipe using learning paths. the purchase_date in my tx_windows is not of required type. it is of string type. It is string and because of that i cannot perform certain window recipe functions on the column. So i did the prepare recipe and followed each and every step in the tutorial on dataiku academy. In the extract date components step after delete and rename columns step in prepare recipe tutorial, in the picture shown it is clearly seen that after extracting date components step, the column which i need: purchase_date has changed its type from string to date but mine is not changed and i haven't miss any step
Answers
-
Hi Hemakshi,
I hope that you are doing well.
I don't have much visibility on what you are currently doing but I have a few guess on what could be going on that might help. If not, assuming that you are using Dataiku Cloud to follow the learning path, don't hesitate to open up a support chat so that we can help you out more in depth here.
Based on your description I am assuming that you are here: https://academy.dataiku.com/path/core-designer/visual-recipes/1992969
If that is the case and you want to see how the previously completed Join, Prepare and Group part of the tutorial should be done, you can create the Window Recipe project:
You will be able to see the flow as you should have it at this stage of the learning path:
Now where this most likely failed is at the prepare step of the tutorial. Have you made sure that the parse dates step was appropriately completed?:
This is where the type should change from string to date.
Note that this would look a little different and would be referred to as datetime with tz in the latest version of dataiku (if you are using Dataiku Cloud this would be the case so it would look as follow:
Let me know if you are able to work through this or to review the window recipe project in learning project to help you go through the previous tutorial steps:)
Otherwise don't hesitate to reach out through chat! We will be happy to help you through your learning process
Best regards,
Yasmine
