Hello,
I'm new with FME, and can't manage to solve an issue which seems simple.
I would like to merge several rows in one, based on same values for 2 attributes. I've obtained a list of unique name/date combinations with the matcher transformer.
Moreover, I'd like to create a unique feature for each match, using other attributes.
I tried to explain it with the example below :
I have the following data :
IDNameDatePlace_APlace_BPlace_C1Tom26-07HouseMarketSchool2Tom26-07MarketSchoolShop3Jerry26-07House
Market
School
4Jerry03-08Market
School
Shop
Since the Name and Date are unique for rows 1 and 2, I want to merge them in a unique feature (which would be chain_1-2.
Then, I want to recreate a chaining House - Market - School - Shop, by comparing :
- Place_B (1) with Place_A (2)
- Place_B (2) with Place_A (3)
- and so on.
I'd like to obtain this kind of result :
IDNameDateChain_link_1Chain_link_2Chain_link_3Chain_link_4chain_1-2Tom
26-07
House
Market
School
Shop
3
Jerry
26-07
House
Market
School
4
Jerry
03-08
Market
School
Shop
I've used a sorter by the ID, but then I'm stuck...
I guess I must create the new attributes with an AttributeManager, but have no idea how to compare different features atferwards.
There must be many possibilities with different transformers, but I've never succeeded...
Thanks for your help !