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.

  

Tags (1)

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 :-)

 

 


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending 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 :-)

 

 


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending 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.

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.