topic tsort row without group by column in Talend Studio

tsort row without group by column

Franz3 — Thu, 21 Jul 2016 10:19:51 GMT

Hi,
i want to do a group by in my flow and to use tAggregateRow,
problem is i don't want the group by column to be in the output, is it possible?

And i would like to know if the concatenation is possible rather than liste in the fonctions

Re: tsort row without group by column

Anonymous — Fri, 22 Jul 2016 04:15:13 GMT

Hi,

problem is i don't want the group by column to be in the output, is it possible?

Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

Re: tsort row without group by column

Franz3 — Fri, 22 Jul 2016 09:17:02 GMT

OK.
Column1;Column2;Column3
Max(Column1)group by Column3;Max(Column2) group by Column3