Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Store Into Error In QlikView with SQL

Still new to QlikView and SQL, but have a load statement that used to work, made some edits/updates and now the STORE INTO statement does not work.


Can anyone provide some help/direction?


We tested the non-working one by commenting out the STORE INTO and the DROP TABLE sections and received no error messages.  Once we re-activated the STORE INTO section, we receive the error that the table is not found.


Again, this worked in the first version, just not in the second one.


Any help is greatly appreciated!

7 Replies

Re: Store Into Error In QlikView with SQL

Have you checked the table name created when you don't add the STORE and DROP Statements. Does it match with what you are adding to your STORE statement? That would be my first check.

Not applicable

Re: Store Into Error In QlikView with SQL

Yes, this was our first check.  We even deleted it, retyped it in and then copied and pasted it down in the store statement. 

Re: Store Into Error In QlikView with SQL

Hi Karen, maybe the new sql returns the same fields than the previous loaded table and now is autocontatenating. To check this you can avoid autoconcatenation using 'NoConcatenate':

UniqueClinicalReviews: //1 per auth per day per user

NoConcatenate LOAD *;

sql ...

Not applicable

Re: Store Into Error In QlikView with SQL

Thank you for the suggestion.  Just tried this and it does not change the error.  Not sure what it could be.

Re: Store Into Error In QlikView with SQL

First off and as a general remark: It's always a good idea to include the error message itself or a screenshot thereof in your original post, as the qualification "it doesn't work" is pretty useless information to work on. Community members do not often post "it works the first time!" at the beginning of a thread. Actually they never do.

An easy test you could try to check the root cause is what you already explained in you first post: comment out the STORE and DROP statements in the Non-working document, reload it again and open the Table Viewer (Ctrl-T). Does it display any tables to store? If not, then why? We cannot check the conditions of the SQL Select statements, as we do not have your data sources at our disposal. But you do. Maybe the (changed) WHERE clauses do not extract any data from your source DB and as a result won't create an internal QlikView table to store on disk?

Best,

Peter

Re: Store Into Error In QlikView with SQL

Did you check the table name in the table viewer (Ctrl + T)?

Not applicable

Re: Store Into Error In QlikView with SQL

Thank you for the feedback.  I fear you are right.  There is a problem with this table being created as it brings nothing back.  Without the STORE and DROP statements, there is still no table created when we check (ctrl - T).  We are now working on fixing that.

Thanks again.

Community Browser