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:
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.