How to remove a row with a specific ID from a Data Table?

Help
1

What is the command to remove a particular row with a specific ID from a Data Table in UiPath.

2

@vivek_Chowdary,

Use Remove data Row activity to remove the row from dataTable.

3

how to remove the row based on ID?

4

@vivek_Chowdary,

  1. Iterate dataTable using for each row activity
  2. If row(“ID”).toString = ''requiredValue"
    Then use Remove Data Row activity and pass dataTable name and row
5

what is the value to be entered into the row field in Remove Data Row activity?

6

hiii
@vivek_Chowdary
Try this sample workflowMain.xaml (9.8 KB)

7

@monika.c

From where did you get that MethodName?

Its showing as error when I type in the same name.

8

@vivek_Chowdary,

This method will work when DataTable contains one matching row only.

9

But what should be entered into the row field in the properties?

10

@vivek_Chowdary

put the current row from the for each activity. If the row name is “row” then use it in the properties field.

11

@vivek_Chowdary,

Find the attached workflow.

Main.xaml (14.7 KB)

12

@monika.c

Its working fine for 1 ID. But its not working for multiple ID’s.

13

Hi @vivek_Chowdary

use the for each activity and list of Id which you want to remove from the table
Iterate over a list and inside the for each activity pass the one by one list item when in ID in your case to the remove data row then it will remove the data row from the datatable

Hope helpful

14

hii
@vivek_Chowdary
For multiple ID’s you can assign…
data_to_del=dt.Select(“[Name]=‘Ron’ or [Name]=‘John’ or [Name]=‘Ram’”)Main.xaml (9.9 KB)
Hope that works for you…

15

Yes… use Filter DataTable Activity for removing row with specific ID

Capture
Capture857×470 11.8 KB

“ID” is your column name and “A005” is ID …it will delete entire row which have ID “A005”

16

Thank you very much, it worked!

17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.