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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.