How to compare roads attributes in two cities?

@bobo​ Can you attach a small sample dataset? Someone might create an example workspace for you.

What you need to do is process the lists you've created. Have a look at the many list processing transformers available in FME. If those don't quite work ten you might need to revert to PythonCaller - see the very end of the article above for a small example of using Python with FME lists

Hi @Mark Stoakes​ , I've upload a sample dataset. I want to put the attributes of each two roads on both sides in the same list, then I can compare if their attributes are the same. May I can use Intersector to get the intersect point and then PointOnLineOverlayer to create the list. For example, road A and road C in list 1, road A and road D in list 2. But now I can only get road A, B, C, D in same list.

You can use a NeighborFinder it looks like. To compare both sides, add a 2nd NeightborFinder with the inputs switched and that should give you all possible combinations.

Workbench

Table

@bobo​ Thanks for including the data. NeighborFinder will work as suggested by @jlbaker2779​ . You could add a Group By: Name so only the same roads match.

Or use the SpatialRelator, something like this:

example workspace attached (FME 2020.2)

Thanks Mark, but sometimes each name of the intersected roads may not be the, I mean that there're​ maybe four names for four roads, then group by may not work as expected.

@bobo​  In that case drop the group by and add a ListExploder. That will give you every pair.