I have a requirement to split an element (field data), can I achieve this by using Data Process shape?
In Salesforce there is a PRODUCT CODE and COUNTRY CODES fields, and both are multi pick list The elements will hold the data like for example:
PRODUCT CODE is P1
COUNTRY CODES are AU,NL,US.
Which means one product is selling in 3 countries. I need to split the country codes and send them as 3 separate records to the target.
Target system profile is jSON not a flatfile
Could someone please suggest on how to achieve this.