Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Formula to calculate line distance

Seffana_
7 - Meteor

Hello,

 

I am in the middle of doing the Alteryx Weekly Challenge #26. 

 

I would like to know if there is a way for me to calculate the distance of the lines I have created from the formula tool in the Path column. Cannot do it with the spatial Distance tool. 

Capture.PNG

 

Any help would be appreciated!

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus
Did you try using this function in a formula tool yet?

ST_Distance(object1, object2, units) returns the distance in specified units from object1 to object2. Supported units are Miles (Mi), Kilometers (KM), Meters, Feet.

This function returns a numeric data value.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Seffana_
7 - Meteor

Hi, 

 

I have tried that as well but I only have one object to put in there which is my [Path] column, so that does not work.

Thableaus
17 - Castor
17 - Castor

Hi @Seffana_ 

 

Have you tried the Spatial Info Tool?

 

Length.PNG

 

Cheers,

Seffana_
7 - Meteor

Hi Thableaus, 

 

I had no idea about that tool! Thank you! =)

 

Cheers, 

 

Seffana

Labels