Subscribe to this thread
Home - General / All posts - How to obtain only one branch in a line ? (SQL - M8)
vincent

1,717 post(s)
#18-Jun-18 21:42

Hi,

I cannot find the SQL way to obtain a line composed of only one branch. I have a set of lines, containing various branch counts. I would like to obtain the same lines, but with one branch per line.

In the GUI, the JoinLines transform does it. But in SQL, JoinLines requires 2 inputs (the 2 lines to be merged).

Any suggestion ?

tjhb

8,227 post(s)
#18-Jun-18 21:46

Aggregate with AllBranches, pass the result to Normalize (i.e. metric), then SPLIT BY Branches().

This requires one wrap (subquery).

tjhb

8,227 post(s)
#18-Jun-18 22:01

...Sorry, that's more than you need, assuming all your multi-branched lines are otherwise continuous and separate.

In that case you only need Normalize().

vincent

1,717 post(s)
#18-Jun-18 22:05

That's what I was gonna post ;)

Thank you !

Manifold User Community Use Agreement Copyright (C) 2007-2017 Manifold Software Limited. All rights reserved.