New Living In SCRIBE Online Blog Post - SCRIBE Labs - Variable Connector Used To Control A Loop (Dynamically) March 09, 2018

Recently, while working on a data migration task, I had a requirement to transform data stored in a string delimited by ";" and parse it to create multiple line items in the target systems. Here is an example as a visual:

 

Source:

productA, productB, productC, productD...

 

Target:

productA

ProductB

ProductC

ProductD

...

 

In the target system, each product would be a line item on an opportunity. In the source system this was all listed in a text box as a string and delimited by ";". Also the cell where this data was in the source could be null, have one item, ten items, fifty items, etc. So I needed a way to loop through this.

 

http://livinginscribeonline.blogspot.com/2018/03/scribe-labs-variable-co...

(2) Answers

Login