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.
Hi @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.
I 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.
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.