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.
+51Hi @allensong
Did you try to do this action with the transformer FeatureMerger?
Thanks,
Danilo
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.
+60I do this with an AttributeCreator, Enable Adjacent Feature Attributes. Then you can, like in Excel, compare with previous or next row.
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.
+60Thanks 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.
