I have a series of flow paths along a network, each with a unique ID. I want to essentially produce an elevation profile graph along each path by sorting the data and writing into an excel template.
I have split the single paths at each node, and linked the elevation of that node to each _from_node and _to_node. However, i'm struggling to figure out how to sort the data in the order of the path. Each path doesn't follow the pattern of Node 1 - Node 2 - Node 3, etc. Some will jump around, e.g. Node 1 - Node 2 - Node 13 - Node 7, and so on.
The information is contained within the _from_node and _to_node attributes, but i cant figure out a way to sort this data, apart from possibly using an indefinite number of joins on the _from_node and _to_node attributes.
Any ideas would be greatly appreciated!
Thanks!
Jack