How to count the number of values per column / How to simulate the excel function "COUNTA"

MPB_
MPB_ New Altair Community Member
edited November 2024 in Community Q&A
Hi there,

is there a way to simulate the excel function COUNTA in rapidminer?

This function counts the number of entries in a column or in other words, the total number of non empty-values in a column.

The count functions I tried in Rapidminer are mostly counting occurance of each value in a column, but not the absolute number of all entries in a column.

Have a nice day :)

Best Answer

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓
    Hi,
    Aggregate with count and no group by statement should do it?

    Best,
    Martin

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓
    Hi,
    Aggregate with count and no group by statement should do it?

    Best,
    Martin
  • MPB_
    MPB_ New Altair Community Member
    Works perfectly fine. Thank you very much