[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] distinct moves problem
Hi all, Just wanted to say thanks once again for helping questions. This is the best list I've seen for genral helpfulness and good things! Just a quick question, with the same data.. <LOG> <DIRECT> <COMMUNICATION_TYPE> PAGETELL </COMMUNICATION_TYPE> <Invoc_serial> 27 </Invoc_serial> <Serial> 3087908 </Serial> <USAGE> TELL </USAGE> <MESSAGE_TYPE> EMOTE </MESSAGE_TYPE> <CHARACTER_ID> 10010 </CHARACTER_ID> <CHARACTER_STATUS> 3 </CHARACTER_STATUS> <LOCATION_ID> 45040 </LOCATION_ID> <TARGET_CHARACTER_ID> 444444 </TARGET_CHARACTER_ID> <TARGET_CHARACTER_STATUS> 6 </TARGET_CHARACTER_STATUS> <TARGET_CHARACTER_LOCATION_ID> 23222 </TARGET_CHARACTER_LOCATION_ID> <MESSAGE>hello</MESSAGE> <TIME> 'Mon, 26 Nov 2001 15:40:29 +0000' </TIME> </DIRECT> etc etc 50,000 or so times </LOG> I also need to track the movement of a character. So for example I know that a certain character_id has been in say 25 rooms of which 9 were unique, but I cant see how I can work out the number of distinct moves he makes using xsl. So I can get output like this:- Ch-ID in-room Message Target-ID time 23470 45040 Hello 12345 10:19 23470 43333 Hi 23432 10:23 23470 45040 Yo 43333 10:44 etc.. etc.. This tells me he was in a total of three rooms of which 2 were unique AND he has made 2 MOVES so far. So I need to work out the total number of distinct moves per character-ID, with a total and average for all of them. Any help gratfully received, Cheers Ahmad XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|