You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-03-29 13:48:39

jevans23
Member
2 posts

jevans23 said:

Struggling with Row Aggregation

Tags: [date]

I have a input source with 4 columns, ID, Date, Hour, FlowRate and I want to get a minimum & maximum flow rate grouping by the 3 other columns, but no matter what I try, it doesn't group.







So for the following lines:

ID;Date;Hour;Flow
9;20170329;07;0.467
9;20170329;07;0.411
9;20170329;07;0.411
9;20170329;07;0.389

I would expect to get one row back:

ID;Date;Hour;minFlow;maxFlow
9;20170329;07;0.389;0.467

but instead what I am seeing is:

ID;Date;Hour;minFlow;maxFlow
9;20170329;07;0.467;0.467
9;20170329;07;0.411;0.411
9;20170329;07;0.411;0.411
9;20170329;07;0.389;0.389

This is on Open Studio 6.3.1 - I'm sure I'm missing something very simple but for the life of me I can't work it out. Any help would be greatly appreciated.

Offline

#2 2017-03-29 14:46:22

jevans23
Member
2 posts

jevans23 said:

Re: Struggling with Row Aggregation

Right - it's taken me all morning but I think I've actually cracked it - the timeid and hour fields were set as Date (basically the same field with different date patterns), but converting them before the Aggregation to Strings gives me the right result.

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy