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.

Outcomes