Distinct Strings grouped by day!

[amba1]

Hi there,

I have a file that looks like this

DATE;CODE

31.08.2021;XX

31.08.2021:XY

31.08.2021;XX

31.08.2021;A*B*

31.08.2021;A*B*

31.08.2021;XX

01.09.2021;XX

01.09.2021;XX

01.09.2021;XX

There's:

• 3 x XX
• 2 x A*B*
• 1 x

I want to select the distinct codes grouped by day. My output file would then be

DATE;CODE;COUNT

31.08.2021;XX;1

31.08.2021;A*B*;1

31.08.2021;XY;1

01.09:.2021;XX;1

I use a tAggregateRow to sum the count and group them by day. But how do I sum the distincts only?

I know I can just select distinct and count them with an aggregaterow, but I want to output them as well

[amba1]

This was pretty easy to do with the tuniqrow component.

File > tuniqurow on code > tmap > taggregaterow to count and done 🙂