Linq instead of an if and for condition

[yash.choursia]

Hi Team,

I have a for loop inside that i have an if condition, but i want the exact same thing using LINQ. Please help.

Attached the condition.

[ppr (Peter Preuss)]

it looks like that the if can be avoided when changing to:

For each activity (NOT for each row activity) item in YourDataTableVar.AsEnumerable.Skip(X).Take(Y)
| TypeArgument: DataRow

• Assign Activity: item(“Status”) = “Your Value”

X = StartIndex + 1
Y = EndIndex - StartIndex + 1

[Brian_Mathew_Maben]

Hey @yash.choursia ,

You can try this using invoke code activity

For Each StatusRow In Status_OriginalFile_DT.AsEnumerable
StatusRow(“Status”) = If(‘Insert the if condition’,“Stock Exists”,Nothing)
Next

Output:

[Quenton_Wayne_Rebello]

@yash.choursia , This method worked for me!!

[Brian_Mathew_Maben]

Hey @yash.choursia, Any Updates?