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.
Solved
split single record to multiple records
Best answer by mark2atsafe
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
+19- Contributor
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).
+49- Safer
- Best Answer
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?
takashi wrote:
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?
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.