Hi Team,
How do we Concat a $ for example to the existing cell values of a column at once.
The data is huge.
Hi Team,
How do we Concat a $ for example to the existing cell values of a column at once.
The data is huge.
@MANISHA_V_ARORA
give a try on
Input, Output:
In case of origin column is unneeded, we can:
have also a look here on how it was done with the url:
@MANISHA_V_ARORA - Here you go…
Invoke Code
DtInput.AsEnumerable().ToList().ForEach(Sub (row) row("Amount") = "$" +row("Amount").ToString)
Why have you added .tolist()?
@kumar.varun2 - Taking each row and convert it to a list …and then looping each row to do a necessary update…
Sample video here: Updating single / multiple columns using single of code in UiPath - YouTube