How to filter by date in the tdbinput

Anonymous — Sat, 16 Nov 2024 05:15:23 GMT

Hi!

I'm with TOS for Big Data and I want my tdbinput to be filtered in a variable way, taking into account these two dates

Last_date_update: it is a variable date that takes into account the last time an extraction was made in my system.
Sysdate

How can I filter directly in tdbinput to only use the data between those two dates?

Thanks!

Regards

Re: How to filter by date in the tdbinput

Anonymous — Wed, 17 Jul 2019 14:56:43 GMT

Hi,

The most easy way is to use context variables. Please assign the values to these variables and assign these variables as parameters in your tDBInput. For example, please refer below link.

https://community.talend.com/t5/Design-and-Development/resolved-How-to-use-context-variables-in-Query/td-p/65786

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 🙂

topic How to filter by date in the tdbinput in Talend Studio

How to filter by date in the tdbinput

Re: How to filter by date in the tdbinput