1

I am trying to rearrange a data in dataiku platform. i am performing several operations, pivoting transposed the data but created more null data. as below

THE data i have

enter image description here

The Data i need it to be

enter image description here

JBE
  • 11,917
  • 7
  • 49
  • 51
Sasidhar Pendyala
  • 11
  • 1
  • Do you have access to Spark on your platform? What tools are available to you on dataiku? – kfkhalili Sep 03 '20 at 07:45
  • If you can run SQL against it then just just do SELECT MAX(tag1), MAX(tag2), ... from TABLE group by TIME – NickW Sep 07 '20 at 19:54

1 Answers1

0

This question is quite old but you could simply use a group visual recipe on this dataset. you would group by time and for example make the sum of your 'tags'. you could also use some code but in this instance it's a very simpe operation in dataiku.

leldo
  • 386
  • 2
  • 9