Remove data on datatable

Help Activities
, ,
1

is there a way to remove this firrst data? they are inside this table io_dt_transactionPL

image

2

Hi @shanti_18

You can use Remove datarow activity. if you want to remove the first row, for the row index property of this activity, provide the value as 0 as 0 refers to the first row of the datatable.

image

https://docs.uipath.com/activities/other/latest/workflow/remove-data-row

I hope it helps!!

3

Hi @shanti_18

Use the remove data row activity to remove the first row.
In the Datatable field pass the datatable variable.
In row Index field give the value 0. Then it will remove the first row.
image

Hope it helps!!

4

image
like this sir?

5

Yes absolutely @shanti_18

6

@shanti_18

Try this in an assign activity:

YourDT = YourDT.AsEnumerable().Skip(1).CopyToDataTable

7

I hope you got the Solution.

I have already tried this its working.

If you got the solution Make mark it as solution which help for others.

Happy Automation!!

8

image
not working on my end

9

Have you passed the datatable variable in the Datatable field.
If 0 not works try with 1.

If it not works try the below syntex
yourDataTable.Rows.RemoveAt(0)

Hope you understand!!

10

@shanti_18

Try this:
YourDT = YourDT.AsEnumerable().Skip(1).CopyToDataTable

11

didnt work on my end

12

@shanti_18

Did it throw any error or simply it didn’t perform.

13

Could you please confirm io_dt_ argument is datatable datatype or not.
Show the argument panel once.

14

didnt perform sir, what to do?

15

@shanti_18

Use Write range workbook activity after remove data row then check whether the data is printed or not

16

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