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 Column_B by Startswith and count the distinct values in Column_B.

Example:

Column A | Column_B

ABC | A10001

DEF | D10001

GHI | E20001

ABC | B10001

ABC | A10002

MNO | H10007

I will filter Column_A by “ABC” Column_B Startswith(“A1”), the resulting count for Column_B should be 2.

Visualization:

Column_A | Column_B

ABC | A10001

ABC | A10002