topic Re: tAggregateRow in Talend Studio

tAggregateRow

Udhay_BM — Sat, 16 Nov 2024 01:03:09 GMT

Hello All,

I am an BI Intern & got stuck with tAggregate row, kindly find the attached image for reference

I need output to be displayed in one row, which gives me the aggregation of both A & B for date 11-07-2017

for example ("11-07-2017 / 55555 / 111")

Any help would be really appreciated

Regards,

Udhay

manodwhb — Wed, 25 Nov 2020 10:02:39 GMT

@Not defined Not defined , Can you please share the sample input and required out put?

Thanks,

Manohar

Udhay_BM — Wed, 25 Nov 2020 10:24:29 GMT

Hello Manohar,

Thanks for your response,

Input is from Azure & i need output in one row

The complete columns "A & B" must get aggregated for the date 11-07-2017

I think below image will explain you better, I need to get what I shown in Step 4 of image

Regards,

Udhay

Udhay_BM — Wed, 25 Nov 2020 11:30:05 GMT

Hello Manohar,

I could fix the issue

Firstly I converted the date format from "yyyy-MM-dd HH:mm:ss" to "yyyy-MM-dd" using

TalendDate.parseDate("yyyy-MM-dd", TalendDate.formatDate("yyyy-MM-dd", row1.TMST))

Now I grouped the "Date & Column B" against "Column A" using count function and it gave me the desired result

Thank you once again for your support Manohar

Regards,

Udhay