Skip to main content
Question

Transposing attributes similar to Excel

  • April 22, 2016
  • 4 replies
  • 16 views
femo
Contributor
Forum|alt.badge.img+6
  • femoContributor
  • Contributor
  • 43 replies

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?

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.

4 replies

nielsgerrits
VIP
Forum|alt.badge.img+60
  • nielsgerritsVIP
  • 2940 replies
  • April 22, 2016

This article might help.

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...
D
Forum|alt.badge.img+6
  • dbaldacchino
  • 71 replies
  • November 15, 2018

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+20
  • fmelizardSafer
  • Safer
  • 3719 replies
  • November 15, 2018

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
  • dbaldacchino
  • 71 replies
  • November 15, 2018
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 :)

Community Stats

32,084
Posts
121,834
Replies
39,720
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.