How to remove rows whose index are more than 5

[HeartCatcher (Naveenkumar.S)]

Hi All,

I hope everyone doing good.

I Need to remove rows whose index are more than 5, someone please help me how to do so??

Thanks in advance.

[pravin_calvin (pravin kumar)]

Hi @HeartCatcher

Clarification needed!

As you need to take the only 5 rows from the datatable?

Regards

[HeartCatcher (Naveenkumar.S)]

yes correct

[Lokesh.Bysani]

Hi @HeartCatcher

This link would help you

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

refer points 14 and 15

[pravin_calvin (pravin kumar)]

Hi @HeartCatcher

Use the expression below!

DT.AsEnumerable.Take(5).copyToDatatable

This will fetch only five rows from the datatable

Regards

[nikhil.girish]

hi @HeartCatcher
if you need only 5 rows you can use something like this in assign activity

Dt2 = Dt1.Clone

Dt2=Dt1.AsEnumerable().Take(5).CopyToDataTable()

[nikhil.girish]

@HeartCatcher

can you close the topic if your topic is resolved

Thanks
Happy automation

[Shikhar_Tandon]

Hi @HeartCatcher,

Use an excel application scope inside it use Read Range to read the datatable say the datatable id DTBook.

use Assign activity in LHS use variable say DTModified with type as Datatable in RHS write something like DtBook.AsEnumerable().Take(5).CopyToDataTable()

which gives you DTModified = DtBook.AsEnumerable().Take(5).CopyToDataTable()
this will give you 5 rows from the starting of datatable

Thanks