How to delete a row from data table

Help
, ,
1

I have to delete a row that contains a particular string variable from a data table. string variable is input from user and I need to delete a row which contains this string variable value.

3 Likes
2

string value will be a full name… single variable is enough for a full name???

1 Like
3

Hi,

Hope the following helps you.

img20200123-4
img20200123-41087×547 22.1 KB

Regards,

1 Like
4

hey
1 - Read Range
2 - Create a ArrayofDatarow = outDataTable.Select(“[YourColumnName]=‘yourrowvalue’”)
3 - For each loop (System.Data.DataRow) and inside loop use Remove DataRow
Cheers @rifnanahasRemoveSingleRow.xaml (7.5 KB) here is a a sample which might help you

1 Like
6

Hi,

Can you check if TypeArgument of For Each is not object but System.Data.DataColumn?

Regards,

1 Like
8

"[Column1] = ’ “+StrVAr+” ’ "

1 Like
10

image
image1600×900 99.1 KB

it’s working fine for me here

1 Like
11

what is you EmployeeCopyDT variable type
and EmployeeList Variable Type

1 Like
12

both are data tables

13

Did you check my workflow? @rifnanahas

1 Like
14

okay if you are approaching that way datatableVar=datatableVar.Select(“[Column1]='”+StrVAr+"').CopyToDataTable
and use DatatableVar in writeRange

1 Like
15

Now my error has gone. But that particular row is not deleting
sample.xaml (15.4 KB)

16

try nowsample.xaml (16.3 KB)
Before Trying remove that Remove Data row Activity

1 Like
17

row is not getting deleted

1 Like
18

give your excel and tell which row has to delete

1 Like
19

here you go with a sample
hope its resolved
deleterows.zip (16.3 KB)

Cheers @rifnanahas

1 Like
20

here I want to delete the row with Employee xxx. But it shouldn’t be harcoded. xxx should be stored as a string variable .EmployeeList.xls.xlsx (8.8 KB)

21

New folder.zip (12.8 KB)
cheers

1 Like
22

Thank you

24

sorry i didnt get you!

1 Like