+2ColB
2
a
3
a
3
a
2
b
1
b
4
b
3
c
4
c
I have this above input where I would like to delete the whole group (a, b, c) from ColB, if there is a '2' in ColA in the specified group.
For example, if there is a 2 in ColA, the whole group 'a' is removed from ColB (and not just the specified row).
A possible way is: use the Aggregator to aggregate the features grouping by ColB and also create a list attribute storing ColA values, find '2' in the list with the ListSearcher, and restore the original features from only the NotFound features with the ListExploder.
+2A possible way is: use the Aggregator to aggregate the features grouping by ColB and also create a list attribute storing ColA values, find '2' in the list with the ListSearcher, and restore the original features from only the NotFound features with the ListExploder.
Hi @takashi. Maybe, I had put the statement in a partial way. I'll explain it a bit.
I have roads like shown below.
There are groups of roads that I have selected using SQLCreator from the server. Now, I have to find the specific group(like Colb(above), so all the road segments have a common group name) of roads(for which you told the above solution). And after that, I need to find how many roads are just one way and calculating their percentage(info not displayed here).
So, if I aggregate the values like above mentioned, calculating percentage would be a bit of task.
Also, I tried reading about creating list attribute transformers, but couldn't get much.
Thanks.
+45You could use this sort of flow, test for value of 2, then use any features that pass as suppliers in a featuremerger. If you keep only unmerged features that 'discards' the whole group
