Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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