For example, I am splitting 'label' - TCY/D/N3000000. In this case, I only need the 'TCY' to be part of the list. I have multiple labels with different values instead of 'TCY'. I then need to display these as row names in Col A. upon writing to Excel as below: (Col B should count how many 'TCY' labels in the dataset.
Â
DA_List Count
TCY 150
BGS 20
CUR 50
Sounds like a job for the AttributeSplitter, this will create a list with a list element for each splitted item. Next can use an AttributeCreator to create an attribute from a listelement.
Then use an Aggregator to group items by this new attribute and fill the Count field.
The first part has worked, thank you! Which count field do you mean? In the aggregator transformer?
The first part has worked, thank you! Which count field do you mean? In the aggregator transformer?
Indeed, in the Aggregator check Group Processing, then choose Group By the field you created using the AttributeCreator and enter a field in "Number of Aggregated Features".
Thank you, this helped a lot!