Assign DataTable values by LINQ with condition

[SONYC]

Hello,

I would like to create a reusable function that assigns values to a DataTable according to a condition (I am not sure if it is possible for the condition to be an input argument, In order to reuse the same workflow without the condition)

If it’s possible, inside the workflow should be an If statement (if condition present in input):

Then: Assign activity with LINQ expression embedding the condition (intDataRowIndex > 1)

Row.Item(intRowItemIndex) = row.Item(2).ToString+row.Item(3).ToString+row.Item(4).ToString

Else: Assign activity with LINQ expression without condition

Row.Item(intRowItemIndex) = “=”+row.Item(1).ToString

Input/Output:

• dtData

Input:

• isCondition
• intRowItemIndex (for the left hand value in the assign activity)
• for the right hand value in the assign activity, I’m tempted to set an array Of Type Object in input argument, like {“=”, 1, 2} (I would like some advices)

The script is like this

[ppr (Peter Preuss)]

@SONYC

if condition present in input

this part needs to be cleared and defined very strict in detail

But keep in mind:

• compilation cannot be bypassed

[ppr (Peter Preuss)]

Thanks for your PM

also have a look at the LINQ Operators Take/Skip

[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…

[SONYC]

Thanks for the documentation.