Skip to main content

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!

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


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:


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

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

 

 


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!