Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Modified Date for SQL table

Hi

I want to add into my script the date when and SQL table was last modified / updated.

I have done it previously for excel files using filetime( dsfsf.xls), but I am not sure how to do this for an SQL table.

Any thoughts?

Thanks

Phil

2 Replies
Mark_Little
Luminary
Luminary

Hi Phil,

Where do you want to pick this up from. I.e. is it when actual table was updated in SQL or when the SQL table was loaded into QlikView?

Mark

Clever_Anjos
Employee
Employee

It´s only possible if you have a column into your table that holds last modified date (using a trigger for example)