on 11-09-2009 2:11 AM
Hello Experts,
We are getting the data from two different databases into XML document with fields (DATE_TIME, COUNT) and we need to group the data based on the DATE_TIME. How can we do this?
For example: we have the data in XML file
2009-08-31T00:00:00 100
2009-09-30T00:00:00 200
2009-08-31T00:00:00 300
After grouping the data we want the data like this:
2009-08-31T00:00:00 400
2009-09-30T00:00:00 200
Thanks
Mohan
Forget the aggregator and other actions - you're missing the easy way. Use the Crosstab action.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Mohan,
Use a conditional action block and put datecompare( datetime1 , datetime2 ) function available. If the dates are matching then add the count values. Here datetime1 is current repetaer datetime and datetime2 is previous repeater datetime. You have to store prvious repeater datetime in a local property.
-Suresh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
6 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.