I have a data table which contains over 80,000 rows.
As part of my process I need to change data in a specific column that meet a condition in another column.
for example: if column I = “STR1” , replace Column N to “STR2” And if column I = “STR_5” , replace Column N to “STR_99”
and so on…
I can’t do it with For each activity because it is taking too long.
Is there any way performing it in another way?
I tried using Enumerable.Range:
but it just return a list of row numbers and it doesn’t apply to the replace part…
Is there any other way?