For Each column but set a specific number of loops from specific columns?

[Josh_James (Josh)]

Hello,

I am adding queue items to Orchestrator from Studio, but I need to be able to only capture the dates and amounts based on the # of installments. An example from the picture below… There are 6 installments. How do I go about only getting the dates and amounts 1-6 to add to the transaction item in Orchestrator? This way, I won’t have to add a bunch of empty dates and amounts that are not needed.

Thanks!

[ppr (Peter)]

Have a look here

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items fr…

so when iterating over the datarows
we can catch:

datarow.ItemArray.Skip(CountFromAtoM).Take(NoOfInstallements*2)