Question

Excel writing issue

  • 19 March 2024
  • 5 replies
  • 69 views
2
Rank
Badge +1

hello 

i am trying to write something in excel format but the result are like in the picture, how to write the data from the start of each row

please suggest

 

5 replies

nielsgerrits
Rank
Userlevel 6
Badge +33

I suspect the data in your workbench is also not in one and the same row.

liamfez
Rank
Userlevel 4
Badge +13

@2eight Are you saying that there should be only 6 features/rows in your data? If so, is there some attribute which they all have in common, like the features name or id? It looks like you have multiple sources of calculations that perhaps should all relate to the same 6 features, but are currently separate in FME, leading them to be separate in the Excel output.

hkingsbury
Rank
Userlevel 5
Badge +29

As mentioned above by @liamfez if you do have a common attribute between them, you can use the aggregator with that common attribute set as the groupby and ‘Accumulation Mode’ set to ‘Merge Incoming Features’

Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd
2
Rank
Badge +1

@2eight Are you saying that there should be only 6 features/rows in your data? If so, is there some attribute which they all have in common, like the features name or id? It looks like you have multiple sources of calculations that perhaps should all relate to the same 6 features, but are currently separate in FME, leading them to be separate in the Excel output.

hello liam

I've extracted those values from the microstation DGN file, there were only six features,

the goal is to find the difference in terms of XY position of two lines as shown in the picture.

please suggest if any other option/method to find that

 

liamfez
Rank
Userlevel 4
Badge +13

Okay, so since there are 6 features, then I would recommend @hkingsbury ‘s solution to aggregate all of those rows back into 6 features. If there is no common key attribute like a name or id to use, you could create one. If there are 6 features being read in initially, you could add a counter and then use that count attribute as the unique attribute for the group by.

Reply


Community Stats

28,731
Posts
109,535
Replies
36,568
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.