Skip to main content
  • EN

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

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

Reply


Community Stats

30,194
Posts
114,613
Replies
37,855
Members
Terms & ConditionsCookie settings
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.