+5I have 3 tables, a linear tables of sections, a non geometric table of bus lines, and a intermediate table between both, with relations N:M. I need to merge the sections to get the geometry of bus lines. but some of the sections belongs to many bus lines, so I need to "duplicate" some of the sections.
Any idea of how to get the geometry of bus lines?
Thank you again
Best answer by daveatsafe
Hi @pabloolivaresm,
From your description of the tables, I think there should be a row on the intermediate table for every unique combination of section and bus line, so I would use this table as the initial feature set.
Use a FeatureMerger to merge the bus line attributes (Supplier) onto each intermediate table row (Requestor). Connect the Merged results to a second FeatureMerger as the Requestor, with the sections as the Supplier. In this FeatureMerger, set:
The Merged output should give you the individual bus lines with line geometry and all the attributes.
+20Hi @pabloolivaresm,
From your description of the tables, I think there should be a row on the intermediate table for every unique combination of section and bus line, so I would use this table as the initial feature set.
Use a FeatureMerger to merge the bus line attributes (Supplier) onto each intermediate table row (Requestor). Connect the Merged results to a second FeatureMerger as the Requestor, with the sections as the Supplier. In this FeatureMerger, set:
The Merged output should give you the individual bus lines with line geometry and all the attributes.
