Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

compare two date and load results in database

hello , 

I am beginner in talend and i need help 

i have building a job wich load results in database with result of comparaison of two date

in my first component tparam , we have the result of the last update date and in the W-CLIENT 

we have the update date of any enregistrement in the database 

we should have the the enregistrement in the database which the update date >= Tparam date 

 

incremental loading 

there is a screenshot which describe the job 

 

Labels (1)
  • v7.x

1 Reply
Anonymous
Not applicable
Author

It looks like you are trying to prepare a SQL query which is used to return data based on a date comparison. If that is the case, you need to think about the following. Dates are not necessarily converted and formatted as Strings in the correct format for a SQL query. So you will need to use the routines.TalendDate methods to format your date in the correct format to be used in your query. The next thing to think about is that you will need to test this query. The best thing to do here is to test your query using a query analyser tool. I see you are printing your Query to the output, so I assume this is what you are trying.