Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

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


Recommended Posts

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

Link to comment
Share on other sites

  • 3 months later...
  • 2 years later...
×
×
  • Create New...