Hi,
I want to split one record in table2 into multiple records based on attribute value from table1. There is no geometry in both tables. The picture shows what I want to achieve:
Thanks for helping.
Page 1 / 1
My first thought:
Create lines for each record (using two VertexCreators and 0 as a Y Value).
Then use the SpatialFilter (test on CONTAINS and EQUALS) to match the records from table 1 on table 2 (using Group by ID and TYPE.
Merging the attributes should give table B after retrieving the FROM and TO from the geometry by using two CoordinateExtractors (X Value from index 0 = FROM, index 1 = TO).
I would try using a FeatureMerger to merge table 1 and 2 using ID and Type as the keys to match. Set it up to process duplicate suppliers and to create a list. Then use the ListExploder to explode that list. That should give you the features as shown in the target table
I agree that the FeatureMerger can be used here. However, since there is an unclear portion in the merging rule, an additional process might be necessary depending on the rule. The unclear portion is:
In the target table, the FROM and TO values in the blue rows have come from the table 1, but the values in other rows have come from the table 2. What is the rule to distinguish them?
I agree that the FeatureMerger can be used here. However, since there is an unclear portion in the merging rule, an additional process might be necessary depending on the rule. The unclear portion is:
In the target table, the FROM and TO values in the blue rows have come from the table 1, but the values in other rows have come from the table 2. What is the rule to distinguish them?