Skip to main content
  • EN

Hi,

 

Having trouble describing my problem to Google it, so apologies if I've used the wrong term or missed something obvious here. I'm just starting to use FME so please be nice! :D

 

I have a spreadsheet which contains owners of properties in this format:

PropertyOwner 1 NameOwner 1 Addr1Owner 1 Addr2Owner 2 NameOwner 2 Addr 1Owner 2 Addr 2

 

And so on for up to 4 owners per property. Properties with one owner have blanks in the Owner 2/3/4 columns.

 

I'd like to reformat this to individual records for each owner, like this:

 

PropertyOwner 1 NameOwner 1 Addr 1Owner 1 Addr 2PropertyOwner 2 NameOwner 2 Addr 1

 

Owner 2 Addr 2

 

PropertyOwner 3 NameOwner 3 Addr 1

 

Owner 3 Addr 2

 

PropertyOwner 4 NameOwner 4 Addr 1

 

Owner 4 Addr 2

 

 

In the real file there are several property columns that I'd like to copy down to all other rows for that property, and obviously if there is blanks I don't want to create new rows.

Is this possible in FME? Can anyone point me in the right direction?

 

Thanks,

 

Iain

One possible solution - explode the attributes, set the Owner attribute from the attribute name, remove the owner element from the attributenames, create the attributes from the attribute name values, then aggregate by Owner

split_row_to_multiple.fmwt

Suitably chided by the newsletter I just wanted to say I'm still working through this answer as my FME learning time is limited. But it looks good. I can't set it as accepted until I've managed to go through it though.

Thanks for the reply, it's way above and beyond what I expected!

Suitably chided by the newsletter I just wanted to say I'm still working through this answer as my FME learning time is limited. But it looks good. I can't set it as accepted until I've managed to go through it though.

Thanks for the reply, it's way above and beyond what I expected!

Awesome! Thanks Iain. Welcome to the community and I'm glad we're able to help out.

Reply


Community Stats

30,177
Posts
114,552
Replies
37,840
Members
Terms & ConditionsCookie settings
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.