I do dataset analysis on Contour by using Pivot table. How can I use export the result on Pivot Table back to dataset (follow pivot table’s format)?
Do you mean the option “Switch to Pivoted Data” on the pivot table board, so that you continue using the data in that Path in the pivoted format?
If you want to save the pivoted format, then you have to switch to pivoted data, and then save the dataset like any other.
As @green says, check the Switch to pivoted data toggle on the Pivot Table board then at the end of the path, use the Save as Dataset button to save the output of the path to a new dataset. You can then schedule a build on that new dataset so that it will stay up-to-date with the input data.
Note that if you’re doing more than exploratory analysis, I’d recommend using Pipeline Builder and the Pivot transform for more robust controls around managing a production pipeline.
2 Likes
Thanks Green & Lrhyne. It is solved my problem. It is easier to handling in Pipeline transform. 
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.