Hello All,
I want to aggregate attributes (Clientid) by Run and by date. Please see the attached spreadsheet
Question
Aggregate Attributes by date and by Run
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+63
If you set up an Aggregator and have it group by Bookingdate and Run, then create a list you should be able to get what you're after.
You can then use a ListConcatenator to create a new attribute with all the ClientID's per unique combo of Bookingdate and Run. I've attached a template with a workspace that shows this.
Hope this helps.
If you set up an Aggregator and have it group by Bookingdate and Run, then create a list you should be able to get what you're after.
You can then use a ListConcatenator to create a new attribute with all the ClientID's per unique combo of Bookingdate and Run. I've attached a template with a workspace that shows this.
Hope this helps.
If you set up an Aggregator and have it group by Bookingdate and Run, then create a list you should be able to get what you're after.
You can then use a ListConcatenator to create a new attribute with all the ClientID's per unique combo of Bookingdate and Run. I've attached a template with a workspace that shows this.
Hope this helps.
Thank you for the reply. I want to count distict booking ID with run. The FME shows the list of client id. But it will be great if I get sum of client id and distict count of booking ID by the run. Thank you again.
+19- Supporter
Hi,have a look at the count attribute for a distinct count and the attributes to sum option.
Hi,have a look at the count attribute for a distinct count and the attributes to sum option.
+19- Supporter
Hi,have a look at the count attribute for a distinct count and the attributes to sum option.
In the aggregator there is a setting (Count Attribute) to preform a distinct count per group defined by the attributes in the group by setting.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.