Pivot and Chart-Please help!!!

MARU
Level 2
Pivot and Chart-Please help!!!

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. 

0 Kudos
8 Replies
Berilio
Level 2

Hi, in prepare recipe set "fold multiple columns by pattern" step to convert data columns in rows, and next parse date step.

Then in chart tab you can show values(sum) by date and Metric  and you can filter by P.

 

MARU
Level 2
Author

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.Cap1.PNG

 

 
 

 

0 Kudos
CoreyS
Dataiker Alumni

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 AcademyThe 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!

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!
0 Kudos
MARU
Level 2
Author

I have completed the basic trainings but I'm not sure what regex code is in the fold and Dataiku notes are not helpful as well.

0 Kudos
CoreyS
Dataiker Alumni

Hi @MARU thank you for your feedback. Here are some additional resources you may find helpful:

I hope this helps!

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!
0 Kudos
MarkPundurs
Level 3

Things we learned while making this work:

CoreyS
Dataiker Alumni

Thank you for sharing your feedback and solution @MarkPundurs. Weโ€™ll be sure to surface your feedback for review. Thanks again.

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!
0 Kudos
Berilio
Level 2

Hi, this pattern is for 0000/00/00 format. First I click on blue words "Find with Smart Pattern" and then i write on "write your own regex here..." box.

Maybe you can try with ([0-9]{4}/[0-9]{2}/[0-9]{2}) pattern. This should work  too.

I attached a screenshoot.

Regards