Skip to main content
Solved

pivot table and aggregate

  • May 27, 2020
  • 1 reply
  • 31 views
istvanv
Participant
Forum|alt.badge.img

I've been at it for a day, time to ask for some help.

i got the JobHistorySnapshot from FME_SHAREDRESOURCE_DASHBOARD/temp and I am trying to create a custom dashboard and need to pivot some data

The upper table is my input data and the lower is the desired output (i didn't add the other 4 columns for the repo_four)

In words it would go like this, group by date and create columns using repository values concatenated with the existing 4 columns and also transfer the values.

 

How could i achieve this?

Thanks

raw data

DateRepositoryQueuedTime.MaxTimeQueuedTime.AvgTimeFinishedTime.MaxTimeFinishedTime.AvgTime2020-05-21-17repo_one0088882020-05-21-18repo_one0030292020-05-21-18repo_two2518.511873.752020-05-21-18repo_four11729.252524.52020-05-21-19repo_one004945.52020-05-21-19repo_two2960296024256242562020-05-21-19repo_four0026047260472020-05-21-20repo_one10.16666666712049.833333332020-05-21-20repo_two0024052240522020-05-21-20repo_four002315423154

Best answer by daraghatsafe

Hi @istvanv,

I don't have the exact answer on how to do this but the tutorial below may help you get started on pivot tables and the AttributePivoter Transformer.

https://knowledge.safe.com/articles/31702/pivot-table-using-fme.html

If you try it out let us know how it goes and if there is anything else we can help with.

Daragh

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

daraghatsafe
Forum|alt.badge.img
  • daraghatsafe
  • 135 replies
  • Best Answer
  • May 29, 2020

Hi @istvanv,

I don't have the exact answer on how to do this but the tutorial below may help you get started on pivot tables and the AttributePivoter Transformer.

https://knowledge.safe.com/articles/31702/pivot-table-using-fme.html

If you try it out let us know how it goes and if there is anything else we can help with.

Daragh

Community Stats

32,076
Posts
121,790
Replies
39,702
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.