how can we filter data on time basis ?,
i have a tmysql input source data, i want to filter data on time ranges.
Ques:- i want to filter data between 06:00:00 to 18:00:00 time ranges .
thanks in advanced,
Solved! Go to Solution.
Hi @vitspltalend if your data is coming from databases like mysql you can filter it in DB itself and bring necessary data right ? Something like
select * from table where dt between '2012-03-11 06:00:00' and '2012-05-11 18:00:00' ;
cause filtering in source(DB) is much more effective than bringing all data to talend and then filter it. Just a food for thought.
hello @Sujay ,
thanks for answer,
It will work fine only for one day data, in my requirements there is multiple days.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables