Change all values in a column

[Jose_Daniel_Grimaldo_Garc (José Daniel Grimaldo García)]

Hi everyone.

Is there a way to change the values of an entire column in a datatable, without the need to iterate through the rows of the datable?

I have a datatable with many rows that I must replicate equal to the number of days it has in the past month. The only value that changes is the date.

Taking the month of October as an example, I currently did a do while that iterates 31 times and in turn inside a for each row to only update the date column. The process works but can take a long time.

Anyone know if I can change the date values for the entire datable to only paste the datatable 31 times

[monsieurrahul (Rahul)]

Hey @Jose_Daniel_Grimaldo_Garc, check this out:

Filter and Update DataTable without loop

I have to read a excel(attached) and from that Datatable, I need to update column(Amount) where column(Currency) = “AUD” then 1.4, column(Currency) = “NZD” then 1.5, column(Currency) = “USD” then 1.6, without using for each.testfile.xlsx (62.5 KB)

[NIVED_NAMBIAR (NIVED N)]

Hi @Jose_Daniel_Grimaldo_Garc

U can try this in invoke code

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(ColumnName)=value)

By passing dt1 as In/Out argument in invoke code with language type as vb.net

Hope it helps you

Regards

Nived N

Happy Automation

[Jose_Daniel_Grimaldo_Garc (José Daniel Grimaldo García)]

Great!
I managed to lower the runtime a lot with this
Thank you so much!