Date and week calculation.

Five Stars

Date and week calculation.

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.

Moderator

Re: Date and week calculation.

Hello,

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

1.png

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Date and week calculation.

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

Five Stars

Re: Date and week calculation.

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

Re: Date and week calculation.

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog