Distinct Strings grouped by day!

amba1 — Fri, 15 Nov 2024 23:46:26 GMT

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;XX

01.09.2021;XX

There's:

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

Re: Distinct Strings grouped by day!

amba1 — Sat, 04 Sep 2021 19:02:56 GMT

This was pretty easy to do with the tuniqrow component.

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