Skip to main content
Question

How to process data different rows compare in FME

  • November 14, 2018
  • 5 replies
  • 257 views

Forum|alt.badge.img

I have a non-spatial data, want to compare every 2 rows: if they has A, B columns same then compare Column C Start, Column D End has the overlap, if it overlap with another row, write that row id to this row column. See attached image, any suggestion for the task? Thank you very much.

5 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • November 14, 2018

Hi @allensong

Did you try to do this action with the transformer FeatureMerger?

 

Thanks,

Danilo


Forum|alt.badge.img
  • Author
  • November 14, 2018

haven't get a very clear idea how to do this: think PythonCaller, looks different to process different rows, I also got all unique combination of Column A and Column B as X cords, Column C start as Y1, Column D as Y2, so if I can make a line from (X, Y1), and (X, Y2) as a line, then if I found any intersection, these rows are need to assign a value. But I am new in FME, has some difficult to implement this idea.


nielsgerrits
VIP
Forum|alt.badge.img+54

I do this with an AttributeCreator, Enable Adjacent Feature Attributes. Then you can, like in Excel, compare with previous or next row.


Forum|alt.badge.img
  • Author
  • November 14, 2018
nielsgerrits wrote:

I do this with an AttributeCreator, Enable Adjacent Feature Attributes. Then you can, like in Excel, compare with previous or next row.

Thanks for the suggestion, I will give it a try.


nielsgerrits
VIP
Forum|alt.badge.img+54
allensong wrote:

Thanks for the suggestion, I will give it a try.

Let me know if you need more help. Please add a sample of your data so I don't have to recreate it from the screenshot.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings