Romve a row range from single column datatable

[abdel (Robot usa)]

Hello,

I have a single row datatable and need to keep only rows from index 7, how we can achieve that

[AkshaySandhu (AkshaySingh Sandhu)]

if you have single row then you can keep rows from 7th index ? can you elaborate more (if possible with sample data)

[AkshaySandhu (AkshaySingh Sandhu)]

if you have single column datatable then you can use below
dt_Test = dt_test.select.Skip(7).CopyToDataTable

[abdel (Robot usa)]

@AkshaySandhu

dt_test.select.Skip(7).CopyToDataTable

[AkshaySandhu (AkshaySingh Sandhu)]

given expression is correct. Try to use in assign activity. Also can you tell whether you are using Studio or StudioX ?

Update: Screenshot from StudioX

[abdel (Robot usa)]

no its studio:
Studio 2023.10.11 - 2/3/2025
Enterprise Trial License
Per-user Installation

License Provider: Orchestrator
Microsoft Windows 10 Pro N 64-bit
6.0.29

[prashant1603765 (Prashant Kumar)]

Hi @abdel

Try below expression,

dtSingleColumn.AsEnumerable().Skip(7).CopyToDataTable()

If you found helpful, feel free to tick as a solution.
Happy Automation

[abdel (Robot usa)]

@prashant1603765

dtSingleColumn.AsEnumerable().Skip(7).CopyToDataTable()

not working i need to get all the cells below A7: