Skip to main content
Question

Hi. I have a spreadsheet containing stations, offsets and direction of offset (left or right). This needs to be translated to point data.How would I automate this?

  • December 6, 2019
  • 3 replies
  • 15 views

Hi. I have a spreadsheet containing stations, offsets and direction of offset (left or right). This needs to be translated to point data.How would I automate this?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

Forum|alt.badge.img
  • 104 replies
  • December 6, 2019

Let's say that you have your attributes like this:

Xcoord - the x coordinate

 

Ycoord - the y coordinate

 

Direction - Left or Right

 

Offset - The distance of the offset

Then you can use the VertexCreator to create the points and use the Conditional Value function to calculate the x coordinate for the offset point:


erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • 2179 replies
  • December 6, 2019

Assuming the stations have an X and Y coordinate, you can use the VertexCreator transformer to create points for the stations.

Next you would use the Offsetter transformer to move the points according to the listed offset.

Hope this helps.


  • Author
  • 1 reply
  • December 6, 2019

Thanks for the advice!