How to delete a DataRow from a DataTable in UiPath - Full Tutorial

This video guide shows, how to delte one or more DataRows from a DataTable in UiPath. It's very useful, because a lot of the daily work in UiPath is working with DataTables and Excel Sheets.

🔔Subscribe if you enjoyed

🤖UiPath - Work with Excel and DataTables - Tutorials

#uipath #datatable #tutorial

[RafaelUnreinGomes]

Hello Anders!! Thanks, this vídeo help me so much!!

[BargainBarons]

Hi Anders. I am getting the error: *'Data Table' does not have a public instance method named 'Remove' matching the parameter types, generic type arguments, and generic type constraints supplied to InvokeMethod "Invoke Method".*

Basically, I think it's telling me it doesn't know the method name 'Remove'. What am I doing wrong here?

[nightowlmusic]

Hi Anders, how to delete row 1 and row 2 in simple way ? I only need to delete these 2 rows

[samarthkulkarni]

Hello @Anders Jensen its really helpful thank you soo much..I want to ask you one topic regarding SAP ....Is there a way to open multiple screens for data extraction from SAP ? if yes can you please tell me how . till now i have spend lot of time in this.

[automationra]

I got an error under the assign function. I have already created a variable with a variable type of DataRow but still has an error.

[winger]

Hi Anders can this be done for filtering Date too? If yes, could you please tell me how and what command should be used in the Assign activity value. My objective is to remove dates that are older or equal to current date. TIA :)
Edit: I tried this <= DateTime.Now]) But get a error saying Character is not Valid.

[ridhoalamsyah]

Hello Anderson, how if I only want to delete (emptying) values from Name column but keeps the ID column beside?

[ashwinswain]

there is a Remove datarow activity..can you please explore that n let me know how to use it..it has 3 parameters to fill

[texasviking]

How do you delete the first row of a csv file without using headers. I just need to delete the first row after reading it into a datatable...thanks!

[subbu]

Hi,
Help me How to remove filters in UiPath ??? By using Ctrl+Shft+L

[rpauipathgeek]

Hi i am try the same step but i need to remove multiple data row using same select method but i did not get result Name='Name2')"

[murugand]

Thanks for the video. how can we remove multiple data rows from excel data table. want to read each row and remove the selected rows . example in column 1 we have multi record in same name "Vijay". I want to specify the item rows name ""Vijay " and remove all vijay record from table.

[Arjunprasadjr]

I am trying the same steps but it is not working. I am not sure where I am going wrong