Convert each list element to multiple new attributes

The first step would be to join the master list items to all detail list items using the FeatureMerger (create a list for multiple details).

Assuming the details are always ordered you could the create the attributes with AttributeCreator (or AttributeManager) using the "Conditional Values" option (e.g. SHIRT_TYPE = if _list.ITEM_NAME = "Shirt" Then TYPE Else Null).

Hope this gets you in the right direction.

Hi @t2, I think this workflow does the trick.

1. BulkAttributeRenamer: Add a prefix (upper case item name and an underscore) to the attribute names "TYPE" and "COLOR".
2. FeatureMerger: Merge DETAIL List to MASTER List joining on ID of persons. Important: Set 'Yes' to the Process Duplicate Suppliers parameter.
3. AttributeExposer: Expose the prefixed attribute names.
4. AttributeManager: Remove unnecessary attributes.

Alternatively, the InlineQuerier works as well.

InlineQuerier | SQL Query:

select
    a.ID,
    a.NAME,
    b.TYPE  as SHIRT_TYPE,
    b.COLOR as SHIRT_COLOR,
    c.TYPE  as PANTS_TYPE,
    c.COLOR as PANTS_COLOR,
    d.TYPE  as HAT_TYPE,
    d.COLOR as HAT_COLOR
from "MASTER List" as a
left outer join (select * from "DETAIL List" where ITEM_NAME = 'Shirt') as b
    on b.MASTER_ID = a.ID
left outer join (select * from "DETAIL List" where ITEM_NAME = 'Pants') as c
    on c.MASTER_ID = a.ID
left outer join (select * from "DETAIL List" where ITEM_NAME = 'Hat') as d
    on d.MASTER_ID = a.ID

Hope this helps.

@takashi, Thanks, I appreciate both options. The second option you gave was inline with my fallback to sql, but I wanted to try it more along the lines of what you did in the first option, so thank you for both!

Tom

Hi @Takashi Iijima​, I am following this thread and your solutions are really very effective. Slightly like similar problem, I would like to create two attributes by splitting a 'Road_name' attribute. So when road name is like Harris Rd, I will split them into two attributes 'type' and 'name' by recalling _list{1} and _list{0}. but when the Road_name has three words like David Conway St, I cannot simply do it by recalling _list{0,1}. What else I can do for such situation?