Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
if(caseID>1597000,caseID),
Date(createdDateTime, 'DD/MM/YYYY') as createdDate
where exists (caseID,caseID);
SQL SELECT
caseID,
createdDateTime
FROM myDatabase;
Thanks for your help.
Hi Clive, to speed up set the WHERE clause in the SQL SELECT:
SQL SELECT
caseID,
createdDateTime
FROM myDatabase Where CaseID>1597000;
Hi,
did you try with
SQL SELECT
caseID,
Date(createdDateTime, 'DD/MM/YYYY') as createdDate
FROM myDatabase
WHERE caseID>159700;
?
Let us know...
S.
Hi Clive, to speed up set the WHERE clause in the SQL SELECT:
SQL SELECT
caseID,
createdDateTime
FROM myDatabase Where CaseID>1597000;
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.
It's ok.
Have a nice day!
S.