mapping in IF statement in load script

[Anonymous]

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?

[prieper]

can't see the image, please post your code

[Anonymous]

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.

[senpradip007]

Try Like

if vQVDExists = -1 then

     load statement;

else

     load statement;

end if

[Anonymous]

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.

[Anonymous]

These answers are flagged as correct but are not correct. Not sure how to remove it.