Group by CUBE sql to KNIME

Hi all,
I am new to KNIME but I was using SQL language so far.
So I would like to implement this SQL query in KNIME
SELECT Country,
Month,
Segment,
Channel,
count distinct Custmer_id as cst_cnt,
count distinct Order_id as ord_cnt,
FROM TableA
GROUP BY CUBE ( Country, Month, Segment, Channel);
what is the equivalent in KNIME nodes?

Thank you so much for your reply.

Hi @ChrMavrom

Hopefully my reply to your other related question helps here as I don’t know of a built in way of doing this

Let’s continue the conversation in your other thread:

Closing this one as a duplicate.

1 Like