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
