Skip to main content
November 25, 2021
Question

How to get the count of similar rows in Appian?

  • November 25, 2021
  • 10 replies
  • 0 views

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.

Col A Col B Col C Count
a b c 2
d e f 3
g h i 1

Thank you

    10 replies

    stefanhelzle0001
    Brainy
    November 25, 2021

    Is this about data in a database you fetch using queryEntity?

    November 25, 2021

    Yes, it is being fetched from database. 

    stefanhelzle0001
    Brainy
    November 25, 2021
    tanvirs0003
    Inspiring
    November 26, 2021

    Use Query entity & inside it use query Aggregation, it will give you count

    November 26, 2021

    Can anyone please give me idea how to apply count on multiple fields combination?

    stefanhelzle0001
    Brainy
    November 26, 2021

    What do you mean with "apply count on multiple fields combination"?