Use collection data all at once in calculation

[JoachimGeelen]

Hi, I have a collection with 120 values. In mij calculation I have the next expression: Replace([Data.companies]; [Business.entity]; "") So, I want to check if there are company names with a business entity included and then remove the entity from te name. Currently I succeeded to do it one by one, but I need to do it all at once (check all entities in one run). How can I do this?

[John__Carter]

Hi Jochem - you have 2 options.1) loop through the collection row by row. Although this may appear slow in Process Studio, don't forget that this will execute very fast in Control Room. Switching logging off will also make the loop run quicker.Create a new code stage, similar to those in the collections utility object. For this option I would recommend creating a new utility object and leaving the original untouched.

[JoachimGeelen]

Thanks John, I used the first option and indeed, it doesn't cost anytime running from the control room. Thanks!