delete multiple rows from data table

[sdfjlkfs]

Hi experts

I have a data table like this shape - 

xxxx

xxxx

xxxx

.

.

.

yyyyyyyyyyyyyyyyyy

yyyyyyyyyyyyyyyyyy

yyyyyyyyyyyyyyyyyy

.

.

.

the first part (xxxx rows) are always extra information and the second part (yyyy rows) are the real data. I need to remove the first part (xxx rows) before I start processing the real data part because header row is the first row of yyyy part. I can get the total rows of xxxx lines and I want to use 'delete from data table' but it seems it's only possible to delete 1 row index a time. so I have to use a loop to delete all the xxxx rows. not sure if there is any better way/action for that purpose? thank you in advance.

sd

[FLMike · Accepted solution]

Hello,

It depends on what you need. When you say delete, but you say the Data Table, that sounds like you aren't looking to remove them from the source? If that is true, then what you need is a filter on your items Property of the data table, that forces it to only show the data you want.

Is there a field or value in the rows you DO want, or  a field that has data in a way for the ones you DO NOT want that you could filter on?

Pretending that the good data has a field that always has the number 5, in the items property Filter(datasource, numberColumn = 5)

You can filter on strings with startswith, and lots of other options, which will remove them from the Data Table view or we can remove them from the source and the data table will be good.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey