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, JohnResult Table:
PropertyIDOwnerIsPrimaryOwner1Travis, JamesYes1Stockton, John
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
Thanks a lot. Worked perfectly.