Hi Amit,
I do this in a weird and wonderful way. See if it works for you.
I add an constant attribute value to the spreadsheet features (i.e. field join, value 1). I then do the same thing to the actual feature. Then I featuremerge then with a list, therefore getting one feature with all the spreadsheet values attached to it.
I then explode the list, giving me a line feature for every spreadsheet row.
DistanceSnipper is used next to chop the line to the meterage specified.
Then use the coordinateextractore to pull out the last coordinate (-1). This is the X and Y we need for the point. So just use the 2d or 3dpointreplacer to create the point.
Hopefully that make sense. Not sure if there is an easier way of doing it but that is what I did when I had a similar problem a few years ago.
Cheers,
Todd
Hi Amit,
Just read your question again and realised that you won't need to add a constant attribute because you already have an attribute that will work (e.g. DH, CL etc). So just ignore that part of my response at start at the featuremerger.
Cheers,
Todd
What about the DistanceMarker custom transfer in the FME Store under CustomTransformer_Linear_Referencing folder?
Folks, thanks for replies. I ended up going to the dark-side and using ArcGIS which was incredibly fussy about the line geometry hence wanting to use FME! I'll need to repeat the task down the road, so will keep a note of the posts and I'm going to put in a feature request too.
Thanks again.