Filter datatable - Help

I have a datable with N number of column , also I would get the input in string in the format “aa,bb,cc,ef” - Now I need to Keep only given string value from fixed column ( col 0) and remove the other rows.

aa 12 89 er
ey 29 88 23
cc 03 38 jf

expected output
aa 12 89 er
cc 03 38 jf
Note : String input is dynamic and it might also not be available in data table, eg count of rows will be 0
Could you please share some suggestion to solve it - Thanks

Hi @Fresher

1 Like

Hello @Fresher

Hope you are getting the input as a list. If yes, use a “for each activity” to loop through the list and then inside that use the filter datatable activity. Then in the activity you can create the condition and select whether keep or remove based on your requirement.

So it will help to filter the input datatable based on the list of string that you used in the loop.


1 Like

filterWithStringValue.xaml (12.4 KB)
check out this workflow I have written for you. You have an input string with the commas between each item. So, I split your string and store each item into an array.
arr_string = Split(str_input,“,”)
Then I loop through your data table and if arr_string does not contain the data table’s col0, I remove that row and output the result data table. I hope it helps.

Best Wishes,

1 Like

Solved with above post - Thanks for you reference and suggestion to get the solution :slight_smile:

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