Update column "Comments" based on the search condition from column "Reason Code" using LINQ

[prasath17 (Guru)]

@manjesh_kumar - Here you go…

1. Build Datatable - this is just to show you here. You have to use Read Range and save it to Datatable…

2. Invole Code…

dtInput.AsEnumerable().Where(Function(row) row(0).ToString.Equals("T9")).ToList.ForEach(Sub(row) row(1) = “I love UIPATH”)

My Output - Again, you can replace it with Write Range…

Hope this helps…