Skip to main content
Question

AttributeSplitter - assign a value to a field for the first split item

  • October 24, 2016
  • 2 replies
  • 34 views
F
Forum|alt.badge.img

Hello, I was able to use AttributeSplitter to split a filed delimited by semi-colons into multiple rows. Please see the original table and results below. How can I populate the IsPrimaryOwner field as 'Yes' for the first split item?

Original Table:

PropertyIDOwnersIsPrimaryOwner1Travis, James; Stockton, John

Result Table:

PropertyIDOwnerIsPrimaryOwner1Travis, JamesYes1Stockton, John

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.

2 replies

todd_davis
Influencer
Forum|alt.badge.img+23
  • todd_davisInfluencer
  • Influencer
  • October 24, 2016

Here we go

AttributeSplitter: attribute to split: owners, Delimiter ;

ListExploder: Explode _list{}

AttributeCreator: New Attributes: isPrimaryOwner Attribute Value: Make a conditional (dropdown on the right hand sign on attributevalue) . _element_index = 0 (the number of the element in the list). Output value = Yes

Another New Attribute: Owner Attribute value: _list

F
Forum|alt.badge.img
  • fmenewbie
  • Author
  • October 25, 2016

Thanks a lot. Worked perfectly.

Community Stats

32,207
Posts
122,302
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.