I'm using FME to look at a large directory and filter down through many factors to handle the data within the directory.
One of the stages I am working on is to search for companies that own the data. These we call 'Third Party Users'.
The third Party list is around 60 company names. I've used a Tester for each condition. This works fine.
What I need to know is how many times these particular names were found within this Test.
I just need this as a list seperate to where my workspace goes after this transformer, or it could be added on to the spreadsheet, I don't mind. I'd just like those stats.
I'm struggling with this because this particular list, is not listed as an attribute. They're listed in the tester.
Here is a TEST Example.
Say this is the spreadsheet (my own has about 300,000 rows)
Now, say I want to filter this spreadsheet only on the following companies, and I want to know how many times they exist.
The result should essentially only kick out those where in column A includes AAPG and DPD.
AND should tell me:
AAPG exists 2 DPD exists 2