Filter datatable - Help

[Fresher]

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.
eg:

inputdt
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

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Fresher

Filter datatable based on list of string

arrFilters = {“3”,“5”,“20”,“25”} Assign Activity | dtFiltered is of DataType: DataTable dtFiltered = (From d in YourDataTableVar.AsEnumerable Where arrFilters.Contains(d("YOS").toString.Trim) Select r=d).CopyToDatable

[Rahul_Unnikrishnan]

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.

Thanks

[DarDarSara (Sara)]

@Fresher
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,

[Fresher]

Removing Rows from a datatable where the Value is in an array

Hi, I have an Comma Separated string and I’m looking to remove any rows from a datatable where a column value is equal to one of the items in the string. I can get it working if I’m looking to keep the columns, but don’t know how to do it if I want to remove the columns. I’m using this: (From r In dt.AsEnumerable From s In Variable.split(","C) Where not r(ColumnName).toString.contains(s) Select r).CopyToDataTable But it doesn’t give me the desired result. As an example If Variable = “Tim,T…

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