Skip to main content
Question

Need help to group and transponse excel data based on unique grouped attribute

  • July 16, 2019
  • 4 replies
  • 18 views
M
Forum|alt.badge.img

Hi,

I need help with transponsing the data in the attached "Input" tab to the data in the "Output" tab.

Each row transposed to columns grouped by "f.WorkOrderEquipmentRef.0"-"f.WorkOrderMstNo.0" - e.g. CHM67-1003 + have the group by column data next to it...

I gave it a shot but couldn't get the desired output.

Thanks.

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

takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • July 16, 2019

Hi @mackmk, this workspace example demonstrates a possible way.

transpose-example.fmwt (FME 2019.1)

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
M
Forum|alt.badge.img
  • mackmk
  • Author
  • 6 replies
  • July 18, 2019

Thanks very much for your help Takashi!

I receive few errors when I try to load the file - Please see attachment

 

 

takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • July 18, 2019

Thanks very much for your help Takashi!

I receive few errors when I try to load the file - Please see attachment

 

 

I created the workspace with FME 2019.1 which is the current latest official release version. You can download the latest version from this web page: FME Downloads

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
M
Forum|alt.badge.img
  • mackmk
  • Author
  • 6 replies
  • July 19, 2019

I created the workspace with FME 2019.1 which is the current latest official release version. You can download the latest version from this web page: FME Downloads

Thanks Takashi - I will download and try opening it again.

Community Stats

32,080
Posts
121,818
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.