I've run into a bit of a problem, I'm working on a layer of connected lines which represent geological faults and contacts. These lines were broken into many small segments so to get rid unnecessary line segments and thus reduce the size of the layer. I joined the lines in FME and I joined based on certain attributes that I wanted to preserve (I couldn't preserve them all or the linejoin would not reduce the number of lines enough).
However, now I want to bring back some of the lesser important attributes such as the name's of the geologist who mapped the lines. Each line had a source author name telling me the geologist's name. Now that I've line joined I want to find a way to place these authors name's back into the geolines and have the new single lines that were previously composed of two or more segments to have all the author names. So I want to end up with a concatenated column with the source authors names for each line listed.
If I had two connected line segments: gid source_author
1 Pete Philips
2 Frank Urt
Now when I combine the two lines I lose this information. So I just have:
But what I want is to fill this new line with the previous source authors concatenated together
1 Pete Philips Frank Urt
My brain hurts thinking about it and I haven't really been able to come up with a solution or tried anything that even remotely worked. If anyone has any ideas how I could do this that would be great!
Thanks for the help!
PS. I'm working in Manifold, FME and pgAdmin.