looping for date

sushantk19 — Sat, 16 Nov 2024 01:28:51 GMT

Hello Everyone,

I have a challenging issue with one of my SQL queries.

I have the sql query structure as below: I use amazon redshift database.

select a.*, a.date

from table a

where a.date < '2020-01-01'

Now i want to lookp the same query for dates between 2020-01-01 till max date in my table a.so intead of hardcoded date

'2020-01-01', i want to pass date as parameter to query and loop it till current date.

is there a component in talend to achieve this? how to implement this logic in Talend? do we need to write a SP ? please help

Re: looping for date

Anonymous — Mon, 14 Sep 2020 03:04:04 GMT

@Sushant Kapoor , if you want to do a loop, you can use tLoop component, take a look at the component documentation and learn this component. Let me know if you still have any troubles.

Regards

Shong

topic looping for date in Talend Studio

looping for date

Re: looping for date