I was looking everywhere and I’m unable to find a solution to my problem. I have a datatable consisting of very large records almost 100k rows. What I wanted to do is filter Column_A by value and Column_B by Startswith and count the distinct values in Column_B.
Thank you @Venugopal24 but I need to use command instead of UiPath activity due to the large number of records, because I am going to include it in a for each row loop and assign the resulting count value to a variable. Thank you.
I think my requirements are unclear from the very beginning. I’m unable to edit the original post so please disregard it and read the following.
Hi friends,
I was looking everywhere and I’m unable to find a solution to my problem. I have a datatable consisting of very large records almost 100k rows. What I wanted to do is filter Column_A by value and Use the result in Column_B.
Thank you so much for the effort, but there are truly many records in the datatable and I’m hoping no to resort to UiPath activities like filtering because it is slow. Thank you.