Question

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

M
Badge

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.

1 Attachment

4 replies

takashi
Rank
Userlevel 2
Badge +17

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

transpose-example.fmwt (FME 2019.1)

M
Badge

Thanks very much for your help Takashi!

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

 

 

takashi
Rank
Userlevel 2
Badge +17

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

M
Badge

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.

Reply


Community Stats

28,707
Posts
109,478
Replies
36,552
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.