I have some fields in SFDC that are effectively strings of values - the annoying multi-select lists from Salesforce. E.g. Account_Support__c = 'John Smith;Jack Brown'
I would like to parse those lists and insert them as N:N related items in Dynamics CRM online. so I would have to INSERT multiple rows for each value in the Origin data. Is it possible to do that in one stage? Could I parse that in the Origin query for SF? What type of SQL does that use?
Login or sign up for our forums to connect to the user community.