Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I have attached an excel file that I do weekly with an updated refreshed data. I wanted to mimic this in Dataiku for automation. I don't know much coding so using the prepare recipe but its not working. I need help.
In my attached file, I have a raw extract where I want to "transpose" the dates into rows with naming that column "date". Then I wanted the column "P to be the columns with the Metric. Then I wanted to do the basic chart that looks like that with dates on X axis and filter by "P" and use column "Metric". but unable to do it. I need help!!! I would appreciate a step by step approach since I'm new this and trying to learn.
Hi I used the "fold method" that you showed in the pic but don't understand how are you getting the "Columns to fold pattern" .*?\d\d\d\d\d\d\. It is not working for me at all. I tried doing the "find with Smart pattern" but it is not working. I attached the screenshot.
Hi @MARU thank you for asking your questions on the Dataiku Community! If you haven't already, I'd love to point you to our Learning Paths on the Dataiku Academy. The Dataiku Academy Learning Paths guides your learning on Dataiku from your first steps through progressive mastery of the platform. Complete the learning path and prove your skills by taking the certification exams.
I hope this helps in your data journey here utilizing Dataiku!
Hi @MARU thank you for your feedback. Here are some additional resources you may find helpful:
I hope this helps!
Things we learned while making this work:
Thank you for sharing your feedback and solution @MarkPundurs. We’ll be sure to surface your feedback for review. Thanks again.