Skip to main content
Question

Transposing attributes similar to Excel

femo
Contributor
Forum|alt.badge.img+6
  • femoContributor
  • Contributor

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
VIP
Forum|alt.badge.img+54

This article might help.

D
Forum|alt.badge.img+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
Safer
Forum|alt.badge.img+18
  • fmelizardSafer
  • Safer
  • November 15, 2018
dbaldacchino wrote:

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
Forum|alt.badge.img+6
fmelizard wrote:
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


Helpful Members This Week

Community Stats

31,341
Posts
118,871
Replies
38,944
Members

Latest FME

Terms & ConditionsCookie settings

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
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.