I have a workspace producing various outputs, I'd like to produce a further output which details the number of distinct customers and number of distinct products for each output but this appears to be either convoluted involving multiple steps and statistics calculators or slow involving a count distinct in the inlinequerier. Wondering if I'm missing a trick
Solved
Most efficient way to count multiple distinct values
+15- Contributor
You can use listbuilder followed by a , listhistogrammer
GroupBy the Attribute you want to have distinct element counted for.
+38- Influencer
I don't think that will work, the two things are independent.
e.g. in the following I would want the customer value to be 2 and the product value to be 3
+7Hi @egomm,
When I am in this situation I make use of a PythonCaller in order to create statistics. If you would need some help with that, just let me know!
+17- Supporter
larry wrote:
This custom transformer should do the trick.
larry wrote:
This custom transformer should do the trick.
I also think that Python scripting would be an efficient solution, but if the destination dataset is a database, SQL querying might also be worth to try.
+15- Contributor
@egomm
Your example can easily be solved by..
Matcher followed by a statisticscalculator grouped by fme_feature_type...
Put in a custom for ease of use...
When using custom explode the features so you can use attr_name as input
No need for python or whatever.
And if its in a database then of course you would use sql.
larry wrote:
This custom transformer should do the trick.
A
1
1
1
2
3
0
0
Output should look like:
0 -> 2
1 -> 3
2 -> 1
3 -> 1
sobanmughal wrote:
I am trying to use this transformer to count all the unique values in a column. but does seem to work. need some help. My data as below.
A
1
1
1
2
3
0
0
Output should look like:
0 -> 2
1 -> 3
2 -> 1
3 -> 1
- Group By: A
- Attributes to Analyze: A
- Total Count Attribute: <an attribute name which will store desired count value>
takashi wrote:
Hi @sobanmughal, The AttributeValueCounter counts the number of distinct values for each attribute, I don't think it's suitable to your requirement. You can just use the StatisticsCalculator here. Set these parameters and check the resulting features output from the Summary port.
- Group By: A
- Attributes to Analyze: A
- Total Count Attribute: <an attribute name which will store desired count value>
UniqueValueLogger
https://hub.safe.com/transformers/uniquevaluelogger
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.