Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
madushanfernand
Contributor III
Contributor III

table storing error when using if clause in load script

Capture1.PNG

 

Hi all

above shows the script i have written at loading. it runs without any error if i don't use STORE statement. But when i need to store that table, i used STORE key word and it gives me this error. please could some one help me correcting this?

 

Capture2.PNG

 

1 Solution

Accepted Solutions
madushanfernand
Contributor III
Contributor III
Author

Lots of Thanks for the replies guys. i found the error my self.

it is just a colon missing after the first statement of SQL script.

that is why table not loaded.

View solution in original post

3 Replies
Somasundaram
Creator III
Creator III

Hi,

 

It seems script is correct,

Please data model if table is available or not while running successfully.  and qvd storage path as well. 


-Somasundaram
julien_saintmaxent
Luminary Alumni
Luminary Alumni

hi,

your table has got data ?

just for test, can you put a space between tblconfirmed.qvd and (qvd);

tblconfirmed.qvd (qvd)

 

Bye

madushanfernand
Contributor III
Contributor III
Author

Lots of Thanks for the replies guys. i found the error my self.

it is just a colon missing after the first statement of SQL script.

that is why table not loaded.

View solution in original post