I am currently trying to load a small table in Qlikview that extracts a created date from a large record set where the record ID exists in another table.
The load statement I am using is below. The first record I want to extract starts after caseID 1597000 hence trying to put the greater than statement in. While the load works it takes over 2 hours to run. can anyone suggest a quicker way to perform the load. I have tried a mapped load and also a join but they also take a long time to run. For info the extract to date will be about 1000 records but will grow daily.
Date(createdDateTime, 'DD/MM/YYYY') as createdDate
where exists (caseID,caseID);
Thanks for your help.
Thanks Ruben this worked great I did not think to add the greater than clause in the SQL statement I thought it had to be in the load statement. the load time has gone from approximately 2 hours to 30 seconds.
Thanks Simone you hit the nail on the head with this one. I went with Rubens answer but only because I prefer to keep my field renaming in the load statement rather than the SQL statement (I do not have an idea if that makes a difference at all). The load has gone from approximately 2 hours to 30 seconds.