AnsweredAssumed Answered

How can I map multiple database rows to a single XML profile element?

Question asked by crhea on Dec 7, 2016
Latest reply on Dec 9, 2016 by Adam Arrowsmith

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.

Outcomes