Question

Transposing attributes similar to Excel

  • 22 April 2016
  • 4 replies
  • 2 views
F
Badge

Hello,

I am reading a folder containing various Excel files of the same schema. The difference between the files is the date and the content, the structure is always the same. My goal is to create a line diagram in a new Excel file. I want to use the "ChartGenerator".

My Problem now is to prepare the data to be used within the ChartGenerator:

I will have a bunch of records as illustrated in the "Start" section of the above pic. For every additional date I will have an additional record. I need to convert the data as illustrated in the "End" section. For every additional date I will need an additional column.

The various existing Posts regarding transposing data do not seem to tackle my issue.

Any ideas?

4 replies

nielsgerrits
Rank
Userlevel 6
Badge +33

This article might help.

D
Badge +6

This custom transformer should be included by default in FME as an out-of-the-box transformer @daleatsafe!

https://hub.safe.com/transformers/attributetransposer

fmelizard
Rank
Userlevel 4
Badge +13

This custom transformer should be included by default in FME as an out-of-the-box transformer @daleatsafe!

https://hub.safe.com/transformers/attributetransposer

Yes, this is a very good one. And I think if we included it, if Feature Caching was on, we could do something about figuring out the resulting schema too. Would you mind posting this as an idea? (If I do, it seems a bit disingenuous) Thanks for flagging it.
D
Badge +6
Yes, this is a very good one. And I think if we included it, if Feature Caching was on, we could do something about figuring out the resulting schema too. Would you mind posting this as an idea? (If I do, it seems a bit disingenuous) Thanks for flagging it.

Will do. And it DOES work (deleted my previous comment). Inspector always gets me when it doesn't show all attributes that have been added dynamically, so I thought it didn't work at first glance. It was a long day :)

Reply


Community Stats

28,724
Posts
109,515
Replies
36,561
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.