topic Date and week calculation. in Talend Studio

Date and week calculation.

Anonymous — Tue, 16 Jan 2018 12:36:21 GMT

Hi All,

I have to do this work. Here I have columns like this. Now, I need to do transformation such a way that separate consolidation on basis of amount and week wise. Additionally, one more record need to create based on last 2-3 days of week 4 consolidation data. I uploaded data with this.

columns-Order date,week,amount,product

How to do this in Talend.

Re: Date and week calculation.

Anonymous — Thu, 18 Jan 2018 09:13:46 GMT

Hello,

Do you mean you want to consolidate the last two weeks amount?

Best regards

Sabrina

Re: Date and week calculation.

Anonymous — Mon, 22 Jan 2018 06:25:16 GMT

Hi Sabrina,

Thanks for response.

No, I want consolidation from last 2-3 days of each week.

Week 1- Last 2 to 3 Days consolidation of that week

Week 2- Last 2 to 3 Days consolidation of that week

Week 3-Last 2 to 3 Days consolidation of that week

Week 4-Last 2 to 3 Days consolidation of that week.

Please help me on this.

Regards,

Jagadesh

Re: Date and week calculation.

Anonymous — Tue, 23 Jan 2018 07:43:48 GMT

Sabrina.. Could you put your ideas here...

Re: Date and week calculation.

Anonymous — Tue, 23 Jan 2018 08:45:06 GMT

Hello,

Here exists a tAggregateRow component which receives a flow and aggregates it based on one or more columns.

For each output line, are provided the aggregation key and the relevant result of set operations (min, max, sum...).

Let us know if it is Ok with you.

Best regards

Sabrina