Hi Mark,
I thought that it might not be easy. Would you mind sending me a copy of the
workbench since I am not aware of the location the you have mentioned.
Thank you very much for all your efforts.
Cheers
--
Ron Cook
Geo-Innovations Inc.
11713 10a Avenue
Edmonton, AB
T6J 7A7
cell: (780) 951-0050
Quoting mark2atsafe <[EMAIL PROTECTED]>:
> Hi Ron,
> Good grief this is a problem and a half! But I think I have a
> solution. It works on the sample you provided - though I think you may
> need to tinker to get it working on a full dataset.
>
> I spent a while thinking about this and I can't see a way that the
> Sorter transformer will do what you need. The only way that could
> happen was if the point ID ran in order along the line; and I can see
> from your example that it doesn't.
>
> Furthermore a sort of this type (a bubble sort) requires some form of
> iteration, Workbench doesn't really allow for that. The only way I
> could see of achieving this is to use TCL.
>
> The first thing I considered would be use a ListBuilder to create a
> list of the attributes. Use a TCLCaller to call a TCL script. The
> script would need to sort through the list elements repeatedly to find
> each successive element. Tag the element with an ID number such as
> list{x}.ID. Then back in Workbench use a ListExploder to convert the
> list back to FME features, then use a Sorter to sort by list{x}.ID
>
>
> But having said that I had a bit of a brainwave and created a
> workspace that will do what you need. However it's complicated (17
> transformers) and difficult to explain. The theory: It iterates though
> a set of features by creating a copy of each feature for each
> iteration you need. So I create a list of all the points for a feature
> using the FeatureMerger and then create a separate feature that
> contains the full list using a ListElementCounter/Cloner. Then I use
> GlobalVariables to define the next point to be read and extract that
> feature from the list of the next feature with a ListIndexer. Note the
> use of the function @GlobalVariable(GV) in the ListSearcher to
> determine which element in the list to read.
>
> NB: It all works only because I'm relying on FME to process a single
> feature as far as possible in the workspace. I don't know if many
> people really understand that concept, but it's the entire basis for
> this workspace. If I say so myself, it's a neat trick. In the same
> vein the StatisticCalculators in there aren't needed for calculating
> statistics; I use them to force FME to stop at that point and gather
> all features together.
>
> I really hope this helps. This is one of those problems that starts me
> thinking to the extent I can't get any other work done until I've
> solved it! And of course the only way to prove it works is to actually
> create the solution.
>
> I'll post the workspace to the files section of the group. Let me know
> if you'd like me to email you a copy directly.
>
> Regards,
>
> 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
>
> --- In [email protected], "Ron Cook" <[EMAIL PROTECTED]> wrote:
> >
> > Hello,
> >
> > I am trying to create lines using the pointconnector operator in
> workbench.
> > Each row of data refers to a NEXT_POINT(char) and a PREV_POINT(char)
> > The first point has a PREV_POINT values of A and the last point has a
> > NEXT_POINT value of Z. A unique line is define by the combination of
> > TYP,ST_ID and JOB_NUM How do I sort the rows so that they are in the
> correct
> > order for the pointconnector? Any ideas would be greatly appreciated.
> >
> >
> > TYP,ST_ID,PNT_ID,JOB_NUM,MEAS_ACC,NORTHING,EASTING,NEXT_POINT,PREV_POINT
> > MM,0002,-4230-75,030932,1,63212.74,458589.08,-4138-33,-4138-32
> > MM,0002,-4138-33,030932,1,63212.40,458579.29,-4138-34,-4230-75
> > MM,0002,-4138-34,030932,1,63211.97,458581.98,-4138-35,-4138-33
> > MM,0002,-4138-35,030932,1,63211.89,458565.12,-4138-36,-4138-34
> > MM,0002,-4138-36,030932,1,63211.74,458553.82,-4138-37,-4138-35
> > MM,0002,-4138-37,030932,1,63211.22,458554.15,-4138-38,-4138-36
> > MM,0002,-4138-38,030932,1,63211.56,458564.37,-4138-39,-4138-37
> > MM,0002,-4138-39,030932,1,63211.49,458567.05,-4138-8,-4138-38
> > MM,0002,-4138-32,030932,1,63212.16,458588.87,-4230-75,A
> > MM,0002,-4138-8,030932,1,63211.05,458577.80,Z,-4138-39
> >
> >
> > Thank you
> >
> > Ron Cook B.Sc.
> > Geo-Innovations Inc
> > 11713 10a Avenue
> > Edmonton AB
> > T6J 7A7
> > (780) 951-0050
> >
>
>
>
>
>
>
> 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/
