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.