Updating the master data table with the condition matching two columns

Help Studio
1

Continuing the discussion from How to update the data table column value by identifying a specific with the condition:

Thanks Ankit this worked for me, can i ask you for the statement which includes the condition matching two columns please.

TIA

1 Like
3

Refer This Statement :slightly_smiling_face:

Your DataTableName .Select.Where(function(x) x.Item(“column name ”).ToString.Contains(“value to be matche s”) and x.Item(“column name ”).ToString.Contains(“value to be matche s”).ToArray(0).Item(" paste column name which has to be updated ")) = “put value over here which to be updated in that column”

4

Thanks Aniket for the reply! It worked :slight_smile:

1 Like
5

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