Hi Everyone,
Can anyone please help me, how can I get the count of similar rows in appian as given below. Like if value of ColA, ColB and ColC is same two times then count should give 2.
Thank you
Discussion posts and replies are publicly visible
Is this about data in a database you fetch using queryEntity?
Yes, it is being fetched from database.
Did you try that?
docs.appian.com/.../Query_Recipes.html
Use Query entity & inside it use query Aggregation, it will give you count
Can anyone please give me idea how to apply count on multiple fields combination?
What do you mean with "apply count on multiple fields combination"?
I mean the count should give the group count of col A, col B, col C having simial records.
Did you try multiple groupings?
If you have some code snippets for multiple groupings, would be helpful for me.