topic Re: mapping in IF statement in load script in QlikView

mapping in IF statement in load script

Anonymous — Thu, 04 May 2017 12:22:14 GMT

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?

Re: mapping in IF statement in load script

prieper — Thu, 04 May 2017 13:00:05 GMT

can't see the image, please post your code

Re: mapping in IF statement in load script

Anonymous — Fri, 05 May 2017 05:42:54 GMT

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.

Re: mapping in IF statement in load script

senpradip007 — Fri, 05 May 2017 05:54:37 GMT

Try Like

if vQVDExists = -1 then

load statement;

else

load statement;

end if

Re: mapping in IF statement in load script

Anonymous — Sat, 06 May 2017 07:20:18 GMT

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.

Re: mapping in IF statement in load script

Anonymous — Sat, 06 May 2017 07:42:23 GMT

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