Hi, I have a datatable filled with data. In a for each loop I want to replace a value. How do I do this without exporting it to excel and using write cell activity? Currently my loop looks like this. I wrote the datatable to csv after, but it doesn’t show the new values. I don’t get any error mes…

Agree with Dave, it is not clear whether your If statement goes to True. You could also try adding .ToString to your If condition: convert.Toint32(row("Class").ToString) < 4

Hi @JVDS , I think the issue is not with the UiPath processing, but in the type of the Excel column. You can change the column type of the excel to “Text” and it works as expected as you can see below. [image] [image] Happy coding! :slight_smile:

Hi Udhay, The original datatable is a csv file, changing the value in excel to text doesn’t do anything for csv.

Is there column with index 4 in your datatable? Try Dt.Columns.Count to see if it exists. You can always add a column with a specific name for index 4 before going into ForEachRow. I always find it more reliable to work with column names instead of indices (in case column order changes). instead o…

Yes, there is always a column index 4. I understand what you mean for clarity purposes, but I don’t think this answers my question(?)

It is a legitimate question, because if your if statement never gets to the “true” side, then your assign activity will never trigger. Don’t forget that index starts at 0, so row(4) is actually the 5th column in the datatable. I’m not 100% sure if it’s necessary, but try changing the right side of …

Yes, I undestand and thank you all for trying to help me make my project more readable. I use write line a ton, which is something that is included in the commented out section. Other than that, please let’s just stay on topic of what I’m trying to achieve :slight_smile: row(4).Item.ToString.pad…

We are attempting to help you with the limited information you have given us. We gave the likely problem based on that limited information, and offered some direction on how to try to troubleshoot it to give us some more information. It seems like you know what you’re doing though, so good luck

Hi @JVDS Have a look to the below thread :- [image] Read Csv with Leading Zero Learn How to read CSV with 000123 resut it shows 123 i want data to be seen 00123 using uipath . In that post also it is not solved yet. Happy Automation :raised_hands: Best Regards Er…

I remade the activities and wrote your code in and it seemed to work. Thank you @Pratik_Wavhal , that’s also a helpful topic, thanks for linking this!

For Each: Replace value in a datatable column

Help Studio

Pratik_Wavhal (Pratik Wavhal) August 19, 2020, 5:38pm 10

Hi @JVDS

Have a look to the below thread :-

In that post also it is not solved yet.

Happy Automation

Best Regards
Er Pratik Wavhal

Topic		Replies	Views
Adding Datacolumn to existing Datatable and updating values in newly added Data column Activities uiautomation , activities	6	161	October 5, 2024
How to replace value in datatable inside for each row Activities excel	1	787	July 27, 2021
Source: Assign...Column does not belong to table DataTable Studio studio	12	6893	May 8, 2020
Change all values of column Help datatable , activities , question	8	2624	January 19, 2020
How to replace a column/row value in datatable in Uipath (based on some condition) without using for each row Something Else datatable , feedback , data_manipulation , condition , data-manipulation , if-condition , column-row , datarow , column , asenumerable	6	4569	July 4, 2022

For Each: Replace value in a datatable column

Related topics