Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a problem with a load script statement.
I am checking to see if the QVD exists and if it does, then I use it to create a mapping table, however when it's in the IF statement, it only returns 1 line even though there are over 6 million rows in the table. If I take it out of the If clause, then it works perfectly.
Has anyone else had this problem?
can't see the image, please post your code
Hi Peter
I have attached the image - will you see if you can view it.
I have changed my code since then, it's easier to send the image.
This shows the log file results, so you can see the same code with and without mapping returning 2 different results.
Try Like
if vQVDExists = -1 then
load statement;
else
load statement;
end if
Thanks but that isn't the problem.
Can you see the image?
I'm doing exactly the same load statements in the IF except the one is a mapping table.
The log file shows that the first load loaded 6 million odd records and the 2nd one (in the mapping), loaded 1 record.
These answers are flagged as correct but are not correct. Not sure how to remove it.