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?

  • 6 December 2019
  • 3 replies
  • 2 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?


3 replies

Badge

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:

Userlevel 2
Badge +12

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.

Thanks for the advice!

Reply