Hi, I want to filter out Column values, there are 3 values that are repeatedly occurring, I want to filter out these values in a separate excel sheet. sheet name rename with filtered value.
You can use the below code for getting the duplicate values in a column. Later you can use Remove Duplicate rows
Dim allDuplicates As List(Of String) = dt.AsEnumerable().GroupBy(Function, dr.Field(Of String)(“VMDList”)).Where(Function, g.Count() > 1).SelectMany(Function, g).ToList()
Hi
Did we try with FILTER DATATAVLE activity
Got it!
That should be fine, just use the code that will give you the duplicates and later you may use Write range to add a new sheet and write the new datatable
Exactly
Get the output variable dt
Instead AND operator use OR
Instead of = use Contains
Cheers @Priyanka_Jadhav1
I believe, that is only possible if the repeated values are known.
sounds like you want to create different excels for each occuring region value
Assign activity
Left: TableList | List(of DataTable)
Right
(From d in dtData.AsEnumerable
Group d by k=d(“Region”).toString.Trim into grp=Group
Select gt=grp.CopyToDataTable).toList
Afterwards use a for each activity | item in TableList | TypeArgument: DataTable
and write each table to Excel with write range
The sheetname can be set e.g. table.Rows(0)(“Region”).toString
Case is very close to:
Too many cooks may be
I suggest you to follow any one path first. try the expression and see are you getting the desired output, are you getting the grouping done correctly. you can use any of the expression mentioned above
Hope this is the output expected and you know the text which are getting repeated
Is it right
this is not my expected output, I want to filter region with corresponding article number
Hello @Priyanka_Jadhav1
Kindly delete the other post you created for the same topic.
Did you try the expression I mentioned above? Do not go for Filter data table.
not tried,actually i don’t understand how to use it in my process.
Please refer to the xaml below!
I have created based on your file its working.
Hope this helps you too!
New_Filter_Process.zip (9.1 KB)
Regards
Now its Working,
Thanks & Regards
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.