how to dynamic product date and deliver to others as a parameters by iterate

Highlighted
Six Stars

how to dynamic product date and deliver to others as a parameters by iterate

Hi everyone,

      This have a case. I must dynamic product date everryday.For example,today is 2018-12-13,

then dynamic product date 2018-12-13,2018-12-12,2018-12-11,2018-12-10,2018-12-09,(condition is date >= 2018-12-09),then tomorrow is 2018-12-14,2018-12-13,2018-12-12,2018-12-11,2018-12-10,2018-12-09.

After product date, deliver these date as a parameter by next component iterate.

How can I do it. Who can help. Thank you very much.

  


Accepted Solutions
Employee

Re: how to dynamic product date and deliver to others as a parameters by iterate

Hi,

    Below job can generate the product dates. In this flow,I have created the start date as 10-Dec-2018 .

image.png

 

 

 

The first stage will identify the difference between the input date (in context variable cut_offdate) and current date. It will store the data to another context variable called date_interval.

image.pngcontext variables

 

image.pngtrowgenerator1

 

image.pngtmap1

 

image.pngtconverttype

 

image.pngtjavarow

 

 

Once you get the count, you can generate the values like below flow.

image.png

 

image.pngtrowgenerator2

 You can add a thashoutput in append mode instead of tlogrow to use the product date for later use

 

Warm Regards,
Nikhil Thampi

Please appreciate our members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

 

 


All Replies
Employee

Re: how to dynamic product date and deliver to others as a parameters by iterate

Hi,

    Below job can generate the product dates. In this flow,I have created the start date as 10-Dec-2018 .

image.png

 

 

 

The first stage will identify the difference between the input date (in context variable cut_offdate) and current date. It will store the data to another context variable called date_interval.

image.pngcontext variables

 

image.pngtrowgenerator1

 

image.pngtmap1

 

image.pngtconverttype

 

image.pngtjavarow

 

 

Once you get the count, you can generate the values like below flow.

image.png

 

image.pngtrowgenerator2

 You can add a thashoutput in append mode instead of tlogrow to use the product date for later use

 

Warm Regards,
Nikhil Thampi

Please appreciate our members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

 

 

Six Stars

Re: how to dynamic product date and deliver to others as a parameters by iterate

Hi nikhilthampi,

 

       Thanks for your reply. And I have some idea from your Job.Many Thanks.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch