tAggregateRow

[Udhay_BM]

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]

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

Thanks,

Manohar

[Udhay_BM]

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 · Accepted solution]

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