Need LINQ to update column data for specific scenario

[rishiathawale]

Hi All,

Below is the data where I want to update RS column data.

Condition

Where Column “IT” is Y and column “RS” is N and N/A - replace “RS” column N and N/A with Y

@ppr @Yoichi

Thanks

[rishiathawale]

Able to form the logic.

Please use below code in invoke code activity.

dt.AsEnumerable.ToList.ForEach(Sub(row)
If row(“IT”).ToString.tolower.contains(“y”) And (row(“RS”).ToString.tolower.contains(“n”) Or row(“RS”).ToString.tolower.contains(“n/a”)) Then
row(“RS”)=“Y”
End If
End Sub
)