cancel
Showing results for 
Search instead for 
Did you mean: 

Running a function on all rows in a collection

OngunArisev
Level 3
Hello, Is it possible to run a function (like trimming a string, performing a calculation etc.) over all the rows in a particular column? I know that this can be done by looping over single items, yet this is not my intent. 
1 REPLY 1

Denis__Dennehy
Level 15
Nope -  you have to loop your data to access and update individual rows.  Points to note: this will be far far quicker at runtime than when running in the process flow diagram - at full speed it will be as quick as .NET code looping a datatable.  Also, if you are a developer that knows .NET there is nothing stopping you from building something smart in a code stage (maybe use SQL against a datatable in some way to do what you ask).