@ndhiran - If it’s only 50k rows, then a for each statement is honestly what i’d recommend. It will only take a few seconds to iterate through all 50k rows using a single if statement and an assign activity.
For each row in dt1
If String.Equals(row.item("Shift").ToString.ToUpper,"MSP") Then Assign row.item("Tag_Shift") = "MSP-Mob"
@HareeshMR - I agree linq is likely going to process more efficiently, but the time savings would be minimal on 50k rows. It’s more important that the developer and ALL people that would look at and review the code in the future understand the LINQ statement which is not likely. It also would only take a few minutes max to make the for each statement vs quite a bit longer if you don’t have a good understanding of LINQ syntax