Remove first row using linq query

[Ranga_prasad]

Have a datatable, remove the first row using linq query
Input

Need output

Thanks Advance.

[ashokkarale]

@Ranga_prasad,

Use below code in Assign activity:

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

Thanks,
Ashok

[Ranga_prasad]

Hi Ashok
already used that linq, after using it will skipping the “First Name” row.
is there any linq query to fetch the below rows based on “First Name”
Thanks,
Ranga.

[ashokkarale]

@Ranga_prasad,

What’s your Datatable columns? is it Worker Title?

If it is then Uncheck Add Headers. This will not write the headers/columns.

Thanks,
Ashok

[Parvathy (PS Parvathy)]

Hi @Ranga_prasad

Rather than unchecking Add Headers in the Properties Panel of Read Range Workbook you can use the below syntax to remove Worker Title

dtData = dtData.AsEnumerable.Skip(0).CopyToDataTable()

Thie above syntax will remove the Worker Title row.

Regards