Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
bmenicucci
Creator
Creator

Store statement issues

Hi all,

I need your help as recently I've got some issues using "Store" function. Sometimes, after loading a table with several records, using the following statement

IF NoOfRows('Sales')>0 THEN

     STORE Sales INTO $(vG.ExtractPath)\TempSales.qvd (qvd);

ENDIF

returns nothing (no QVD it's been created), even though looking at the script (please see enclosed picture) you'll see a large number of records written and after executing, I can actually see a full table in Qlik. What am I missing?

Any help appreciated!

Regards

Brunello

Screenshot 2018-03-17 09.56.34.png

11 Replies
swuehl
MVP
MVP

After your NOCONCATENATE LOAD from TempSales, I also miss a sign of the two following LOAD statements to be JOINed to the TempSales table in your script execution window.

Again, I would start with adding more TRACE statements to the script and double checking that executed and looked at script are identical.

bmenicucci
Creator
Creator
Author

Ok Stefan, I'll try to do as suggested: add more TRACE statements and

double check again the script.

Thanks for your time!

Have a great weekend