How to replace the value in the Datatable

[Aibek_Abubakirov (AB)]

Hi Team

How to replace the value in the Datatable

Value 1 → value n

What am I doing wrong?

[hasib08 (Motiwala Hasib)]

IF Condition would be

row(“Name”).tostring.contains(“Value 1”)

Thanks
@Aibek_Abubakirov

[Aibek_Abubakirov (AB)]

@hasib08 Thanks, I managed to find Value

But how now to replace a certain value with value n ?

[supermanPunch (Arpan)]

@Aibek_Abubakirov Since you’re using a For Each Loop, in if Condition after you find the Value Which you want, you can use an Assign Statement :
row(“ColumnName”) = yourValue

[hasib08 (Motiwala Hasib)]

In if condition use Replace function

Thanks
@Aibek_Abubakirov

[Tushar_Karkera]

Hi @Aibek_Abubakirov after condition is true then use assign activity row(“Name”)=“n”

[Aibek_Abubakirov (AB)]

Finds but does not replace

[Tushar_Karkera]

Hi @Aibek_Abubakirov Use Write Range after the loops end.

[Aibek_Abubakirov (AB)]

Thank you all for your help

[CristianZachiteanu (Cristian Nicolae Zachiteanu)]

You can also take look at this:
Replace Values in a DataTable without foreach