Steve, As Jason said, I think your sort order is incorrect. You'll see the Sorter transformer has two buttons - 'move up' and 'move down' in which you can prioritise the order of sorting.
You need to use the 'move up' button to bring LABEL_NUM above ANGLE. The only thing that the FME Sorter won't do is sort one attribute ascending and another descending - but we are working on it and it shouldn't be a problem in this case where you are sorting both in the ascending. Mark Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access > -----Original Message----- > From: Steve Nelson [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 03, 2005 12:46 PM > To: [email protected] > Subject: [fme] Re: Am I using the Sorter correctly? > > > > > I am able to sort these records properly taking the output > example below, and using the sort function in Excel. > > So FME gives me this when I specify to sort on two attributes. > > DISTANCE,QUESTION,LABEL_NUM,ANGLE > 976.529999999999970,q1a_r2, 11,138.310131990239 > 564.659999999999970,q1a_r1, 12,141.777637926361 > 592.440000000000050,q1a_r1, 11,143.517128922147 > 806.549999999999950,q1a_r1, 11,143.754809644134 > 347.870000000000000,q1a_r1, 12,149.284541475274 > 453.889999999999990,q1a_r1, 11,151.852662604772 > 443.029999999999970,q1a_r1, 12,156.319534604435 > 201.470000000000000,q1a_r1, 12,164.595629963999 > 255.530000000000000,q1a_r1, 12,167.897324252283 > 749.509999999999990,q1a_r1, 12,168.37364833234 > 407.240000000000010,q1a_r1, 11,173.22694808632 > 668.149999999999980,q1a_r1, 12,175.363236157931 > > What I'm expecting it to give me is this.... > > DISTANCE,QUESTION,LABEL_NUM,ANGLE > 976.529999999999970,q1a_r2, 11,138.310131990239 > 592.440000000000050,q1a_r1, 11,143.517128922147 > 806.549999999999950,q1a_r1, 11,143.754809644134 > 453.889999999999990,q1a_r1, 11,151.852662604772 > 407.240000000000010,q1a_r1, 11,173.22694808632 > 564.659999999999970,q1a_r1, 12,141.777637926361 > 347.870000000000000,q1a_r1, 12,149.28454147527 > 443.029999999999970,q1a_r1, 12,156.319534604435 > 201.470000000000000,q1a_r1, 12,164.595629963999 > 255.530000000000000,q1a_r1, 12,167.897324252283 > 749.509999999999990,q1a_r1, 12,168.37364833234 > 668.149999999999980,q1a_r1, 12,175.363236157931 > > The sort function in Excel gives me the above result. But > also makes for an addition step. > Still think the Sorter function in FME is not working the way > it should.... > Steve > > --- In [email protected], "Steve Nelson" <[EMAIL PROTECTED]> wrote: > > > > > > I'm trying to sort some data using two different attributes. My > > thinking is that I can sort the data on the one attribute "Angle", > > then sort this sorted data based on "Label_num". But it > seems to only > > be sorting on the one attribute "Angle". Why is there the > option to > > select more than one attribute to sort on? > > > > I'm trying to order this data correctly so that I can then use the > > point connector function. I need the Angle in the correct order so > > that the points connect in the right order, but I also need the > > Label_num in the correct order so that the polygons finish when the > > park num changes. > > > > I'm using the latest beta version build 1624. > > > > Thanks > > Steve > > > > Sample below - the angle order is good. But I need to push all the > > records with Label_num 11 up to the top, and still keep the angle > > order. > > > > Any Suggestions? > > > > > > DISTANCE,QUESTION,LABEL_NUM,ANGLE > > 699.679999999999950,q1a_r2, 11,0 > > 704.919999999999960,q1a_r2, 12,0 > > 401.389999999999990,q1a_r1, 12,1.22767502576637 > > 731.289999999999960,q1a_r1, 12,3.39055534367502 > > 535.360000000000010,q1a_r1, 12,4.46504321411014 > > 600.440000000000050,q1a_r2, 12,6.46602754888675 > > 765.690000000000050,q1a_r1, 12,10.2642586106839 > > 450.630000000000000,q1a_r1, 12,10.9111128222178 > > 946.070000000000050,q1a_r1, 12,11.228194468345 > > 736.029999999999970,q1a_r1, 12,12.7691891765542 > > 608.440000000000050,q1a_r1, 12,15.2777232899028 > > 704.919999999999960,q1a_r2, 12,23.8748940665989 > > 794.320000000000050,q1a_r1, 12,26.8751448176278 > > 598.220000000000030,q1a_r1, 12,29.4392937466317 > > 773.630000000000000,q1a_r1, 12,30.1376750227867 > > 710.289999999999960,q1a_r1, 12,32.0079880432875 > > 995.970000000000030,q1a_r1, 12,41.9760864925623 > > 968.139999999999990,q1a_r1, 12,66.8807464288626 > > 578.580000000000040,q1a_r1, 12,78.4320725554195 > > 867.130000000000000,q1a_r1, 12,85.3713937822455 > > 890.850000000000020,q1a_r1, 12,87.4581330219245 > > 567.169999999999960,q1a_r1, 12,91.8685941724182 > > 668.210000000000040,q1a_r1, 12,94.5484840893826 > > 278.430000000000010,q1a_r1, 12,96.5592151181931 > > 513.750000000000000,q1a_r1, 12,106.327556036807 > > 911.080000000000040,q1a_r1, 12,108.318050175925 > > 518.909999999999970,q1a_r2, 12,115.755401286829 > > 532.860000000000010,q1a_r1, 12,118.707452748748 > > 353.750000000000000,q1a_r1, 12,134.883054990615 > > 259.180000000000010,q1a_r1, 12,136.742075527013 > > 976.529999999999970,q1a_r2, 11,138.310131990239 > > 564.659999999999970,q1a_r1, 12,141.777637926361 > > 592.440000000000050,q1a_r1, 11,143.517128922147 > > 806.549999999999950,q1a_r1, 11,143.754809644134 > > 347.870000000000000,q1a_r1, 12,149.284541475274 > > 453.889999999999990,q1a_r1, 11,151.852662604772 > > 443.029999999999970,q1a_r1, 12,156.319534604435 > > 201.470000000000000,q1a_r1, 12,164.595629963999 > > 255.530000000000000,q1a_r1, 12,167.897324252283 > > 749.509999999999990,q1a_r1, 12,168.37364833234 > > 407.240000000000010,q1a_r1, 11,173.22694808632 > > 668.149999999999980,q1a_r1, 12,175.363236157931 > > 541.960000000000040,q1a_r1, 11,176.10987402871 > > 895.710000000000040,q1a_r1, 12,176.676048256527 > > 999.330000000000040,q1a_r1, 12,177.010171831627 > > 796.720000000000030,q1a_r1, 11,180.638823748566 > > > > > > > > > > > > > Get the maximum benefit from your FME, FME Objects, or > SpatialDirect via our Professional Services team. Visit > www.safe.com/services for details. > Yahoo! Groups Links > > > > > > > > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
