topic Iterate through the date and execute the sql for each date and create a CSV file for each day. in Talend Studio

Iterate through the date and execute the sql for each date and create a CSV file for each day.

Anonymous — Sat, 16 Nov 2024 06:13:25 GMT

Hello,

I am quite new to Talend, and i am having a hard time in one of my usecase in Talend.

Use case is : I have a start date and end_date, and i am loop through the two dates to get the list of dates between start and end date. Later, i am trying to pass the context variable to SQL to get the data for that specific date and create a CSV file for each date. For Example, start_date is 25.03.2019, and end_date is 29.03.2019, the CSV file should be loaded with 25, 26,27,28,29 data. I have been successful in looping through the date, but in SQL, the date is not iterating.

Re: Iterate through the date and execute the sql for each date and create a CSV file for each day.

Anonymous — Mon, 01 Apr 2019 07:09:44 GMT

Hi,

re you trying to give the start date and end date as parameters to tOracleInput component? I am slightly confused here as I could not see any csv file as mentioned in your query. In ideal case, you need to store the start date and end date to a context variable and then pass it as a parameter during later stages.

Warm Regards,
Nikhil Thampi

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