LINQ query for update column value based on condition

Help Studio
, ,
1

Hi all,
I want to update the state column to “AP” when Location is “Vizag” and to “TS” when Location is “KarimNagar” using method syntax. Please anyone guide me.

The image shows a data table with columns for Name, Location, and State, containing entries with various names and locations but no states filled in. (Captioned by AI)
The image shows a data table with columns for Name, Location, and State, containing entries with various names and locations but no states filled in. (Captioned by AI)467×297 7.35 KB

2

@JK_MECH,

Use this LINQ in Invoke Code activity.

dt.AsEnumerable().ToList().ForEach(Sub(row)
    If row.Field(Of String)("Location") = "Vizag" Then
        row.SetField("State", "AP")
    ElseIf row.Field(Of String)("Location") = "KarimNagar" Then
        row.SetField("State", "TS")
    End If
End Sub)

The image depicts a workflow in an automation tool where a data table is built and then modified using code to update the "State" field based on the "Location" field values. (Captioned by AI)
The image depicts a workflow in an automation tool where a data table is built and then modified using code to update the "State" field based on the "Location" field values. (Captioned by AI)566×480 14.9 KB

Before:

image
image361×156 2.55 KB

After:

image
image499×160 2.72 KB

3

@ashokkarale
thank you sir,

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.