HOW TO DELETE UNWANTED ROWS FROM SOURCE DATA TABLE

Help Activities
, ,
1

Hi every one,
i need to select only tow rows and delete remaining rows and update in same data table

This is my input
IN

Expected output:
OUT

i need this updated output in same sheet

2

You can use an assign function with the below input:

yourDT = yourDT.asEnumerable.take(2).copyToDataTable

3

Thank you . But this will not delete my remaining rows in source data table

4

@adarsh_kotagiri

Use Delete Range activity and mention Range as “A4:D6” to delete remaining rows except top 2 rows.

5

Ah sorry, I thought you were talking about removing rows from the DataTable object, not the excel file itself.

Adarsh Kotagiri’s response accomplishes that

6

It will take only the first two rows from the datatable, and assign that to the existing datatable object, effectively deleting remaining rows.

7

you can use the origin rows count and filling up the datatble with empty rows after extracting the top x rows as an alternate

8

thank you every one…

9

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