Skip to main content
Solved

List of locations > from_location, to_location

  • October 29, 2018
  • 4 replies
  • 8 views

Forum|alt.badge.img

Hi,

I have a table of locations that I'm trying to split into from_location and to_location columns as shown below.

Starting with:

Location1234

Want:

from_locationto_location122334

Thanks for your help!

Best answer by hollyatsafe

Hi @ae_jeff,

Is the to location always the feature in the row below? If so add an AttributeManager or Creator and under the Advance headed check the 'Enable Adjacent Feature Attributes' box. Set the Number of Subsequent Features to 1 and then you can use this to create the new attribute, see image below:

Output:

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.

4 replies

erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • 2179 replies
  • October 29, 2018

After reading you can do this using the AttributeCreator with the following settings:


Forum|alt.badge.img+2
  • 719 replies
  • Best Answer
  • October 29, 2018

Hi @ae_jeff,

Is the to location always the feature in the row below? If so add an AttributeManager or Creator and under the Advance headed check the 'Enable Adjacent Feature Attributes' box. Set the Number of Subsequent Features to 1 and then you can use this to create the new attribute, see image below:

Output:


Forum|alt.badge.img
  • Author
  • 7 replies
  • October 29, 2018

After reading you can do this using the AttributeCreator with the following settings:

Works great! Thanks for helping a new FME user, @erik_jan!

 

 


Forum|alt.badge.img
  • Author
  • 7 replies
  • October 29, 2018

Hi @ae_jeff,

Is the to location always the feature in the row below? If so add an AttributeManager or Creator and under the Advance headed check the 'Enable Adjacent Feature Attributes' box. Set the Number of Subsequent Features to 1 and then you can use this to create the new attribute, see image below:

Output:

Works great! Thanks for helping a new FME user, @hollyatsafe!