Remove DataRows from Datatable which is not in the array

[Aleksey_M (RPA_Dev)]

Hello!
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)

[Palaniyappan (Forum Leader)]

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
example.zip (17.9 KB)

Hope this would help you buddy @Aleksey_M
Cheers

[ronanpeter]

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)

[Palaniyappan (Forum Leader)]

did that work buddy @Aleksey_M

[aksh1yadav (AKSHAY YADAV)]

Hey buddy @Aleksey_M

@Aleksey_M

Hello!
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.

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

did that work buddy @Aleksey_M ?

Regards…!!
Aksh