| Author | Message | 
		
		  | mqjeff | 
			  
				|  Posted: Wed May 04, 2011 7:45 am    Post subject: |   |  | 
		
		  | Grand Master
 
 
 Joined: 25 Jun 2008Posts: 17447
 
 
 | 
			  
				| Siva is starting from a message aggregation, that contains two messages in the logical message tree. 
 Siva then wants to combine these two messages into a single message that has the relevant data items sorted and any duplicates removed.
 
 It may or may not at all be as simple as wanting to sort a single list of values.
 
 It could, for example, be sorting a set of Person records by last name, where each Person record has many many fields in it that all need to be kept with the same record.
 
 It is this kind of case that makes one really wish that ESQL SELECT had an ORDER BY clause.
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | khudania | 
			  
				|  Posted: Wed May 04, 2011 7:48 am    Post subject: |   |  | 
		
		  |  Apprentice
 
 
 Joined: 30 Nov 2004Posts: 43
 
 
 | 
			  
				| Siva, please if you could provide a sample of the message with some values and expected expected output. _________________
 If the doors of perception were cleansed, everything would appear as it is - infinite
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | siva1431202 | 
			  
				|  Posted: Wed May 04, 2011 9:02 pm    Post subject: |   |  | 
		
		  | Novice
 
 
 Joined: 04 May 2011Posts: 20
 
 
 | 
			  
				| Siva, please if you could provide a sample of the message with some values and expected expected output. 
 
 reply to this:
 
 <Employees>     <emp><empID>1</EmpID><last>Dill</last><first>Phil</first><salary>100000</salary></emp>
 <emp><empID>2</EmpID><last>Bill</last><first>Fohnny</first><salary>95000</salary></emp>
 <emp><empID>3</EmpID><last>Bill</last><first>Xraham</first><salary>89000</salary></emp>
 <emp><empID>2</EmpID><last>Bill</last><first>Fohnny</first><salary>95000</salary></emp>
 </Employees>
 
 Firstly want this to be sorted using PHPComputenode and JavaCompute Nodes and then Duplicates should be removed from this.
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | siva1431202 | 
			  
				|  Posted: Wed May 04, 2011 9:03 pm    Post subject: |   |  | 
		
		  | Novice
 
 
 Joined: 04 May 2011Posts: 20
 
 
 | 
			  
				| Sorted Using First name and Remove Duplicates using EmpID. |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | khudania | 
			  
				|  Posted: Thu May 05, 2011 1:14 am    Post subject: |   |  | 
		
		  |  Apprentice
 
 
 Joined: 30 Nov 2004Posts: 43
 
 
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | siva1431202 | 
			  
				|  Posted: Thu May 05, 2011 8:54 pm    Post subject: |   |  | 
		
		  | Novice
 
 
 Joined: 04 May 2011Posts: 20
 
 
 | 
			  
				| Ok Thank you. I am trying to build with the code which you have given. |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  |  |