looping for date

[sushantk19]

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

[Anonymous]

@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