Remove rows in datatable that doesn't match a certain criteria

[jakobls]

Hi all,

I’m trying to run through a datatable with a “for each row” loop, and then delete the rows that don’t meet a certain criteria. The criteria to be met is that the row needs to contains the string “was posted in”.

This is how my loop looks like:

My question is what I should Write in the “Row” or “RowIndex” Properties field in order to remove that certain row that doesn’t contain the string mentioned above.

I have been looking for a while in the forum, but couldn’t find any similar cases.

All help is appreciated.

Kind regards,
Jakob

[PrankurJoshi]

You can’t remove a row while in a loop. Instead build a datatable and add data to that table or else use datatable select which would be more smart solution

How to use contains in a select from datatable

I am trying to read datatable where the text coming from another source is larger than the data residing in my datatable. as a result we have to use a “contains” or starts with comparison. how do I achieve this? Attaching a sample xaml for explaining the issue. Please help. Thank you.test.xaml (8.5 KB)

Thanks,
Prankur

[arivu96 (Arivazhagan A)]

Hi,
Try below code
Dt=Dt.select("Message like '%was posted in%'").CopyToDataTable()

Regards,
Arivu

[jakobls]

Hi @PrankurJoshi and @arivu96 ,

Thank you for the replies. I figured out that the “Filter Data Table” activity was the perfect way to solve this. If anyone else should have the same issue, here is how I sorted my table: