I am selecting multiple rows from a SQL table and would like to put the results into a single Salesforce field.
Currently I'm mapping the DB result to a single value in a Flat File Profile, which passes a single document to the FF-to-Salesforce map shape. The second map simple links the new value (which is now a list of strings) to the Salesforce XML element.
Unfortunately, the FF-to-Salesforce shape outputs an XML document per database row, instead of a single XML doc with a single element.
I've attempted combining docs in different places, but can't make sense of why it's being split to begin with.