Skip to main content
Solved

Accumulating and transposing rows

  • August 16, 2019
  • 3 replies
  • 10 views
A
Forum|alt.badge.img

Hi All,

It seemed a bit easy but i am stuck with it now. Can someone please help?

My input is somewhat like this:

 

and my desired output is like this:

The 6 values (Acquisition date, Analysis Date, System, Method, Sample ID and Data filename) are repeating three times in first column and have different values. I have attached the excel file for your reference.

Best answer by takashi

This workflow might help you. The point is to use the AttributeCreator to create new attribute whose name is value of attribute A.

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.

3 replies

takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • Best Answer
  • August 16, 2019

This workflow might help you. The point is to use the AttributeCreator to create new attribute whose name is value of attribute A.

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
A
Forum|alt.badge.img

This workflow might help you. The point is to use the AttributeCreator to create new attribute whose name is value of attribute A.

Thanks a lot @takashi. It worked fine.

A
Forum|alt.badge.img

This workflow might help you. The point is to use the AttributeCreator to create new attribute whose name is value of attribute A.

@takashi Thanks for providing the solution earlier. How do we carry out the same process if we have multiple columns in hand and the rows in first column ?

Community Stats

32,079
Posts
121,811
Replies
39,714
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.