Skip to main content
Solved

pivot table and aggregate

  • May 27, 2020
  • 1 reply
  • 21 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

View original
Did this help you find an answer to your question?

1 reply

daraghatsafe
Forum|alt.badge.img

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings