Remove DataRows from Datatable which is not in the array

I have DataTable, which get from this excel file.
And I have array of string with data {“aaa”,“ccc”,“eee”}
I want get datatable in which the column Role values will be from this array.
DataRows = “bbb” and “ddd” must be delete.

How do this? Thanks!
Example.xlsx (8.0 KB)

1 Like

Buddy @Aleksey_M
here is your xaml buddy
its resolved, kindly check with excel with sheet that has row deleted with ddd and bbb
and array value added to the column Role…finally with no ddd and bbb (17.9 KB)

Hope this would help you buddy @Aleksey_M

I have just created the DataTable in the workflow, but this does what you ask. You can adapt to your needs. It looks at the values and if they are contained in the array, they’ll be copied to another datatable.

Main.xaml (8.4 KB)

did that work buddy @Aleksey_M

Hey buddy @Aleksey_M

here is your xaml buddy
it has been resolved :slight_smile: :wink:
SampleAleksey.xaml (6.8 KB)
Example.xlsx (8.6 KB)

did that work buddy @Aleksey_M ? :smiley: :smiley:


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.