AnsweredAssumed Answered

Field Concatenation

Question asked by gboothpur433142 on Dec 15, 2016
Latest reply on Dec 16, 2016 by Adam Arrowsmith

Hi All,

I have a requirement to concatenate two fields data.

For ex: One agent can sell multiple products like P1 P2 P3

Country Filed is a multi picklist and a cascade filed for Product, county data is like AU, NZ, US... etc


if Agent1 is selling P1 in AU, NZ, US and P2 in AU, NL


I need to concatenate the data as P1,AU,NZ,US | P2,AU,NL as a single field.


Source is Salesforce XML profile and target is tab delimited flat file. 


Could someone please suggest on how to achieve this.


Many Thanks.