topic Re: table storing error when using if clause in load script in QlikView

table storing error when using if clause in load script

madushanfernand — Mon, 28 Jan 2019 09:22:39 GMT

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?

Re: table storing error when using if clause in load script

Somasundaram — Mon, 28 Jan 2019 10:03:09 GMT

Hi,

It seems script is correct,

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

Re: table storing error when using if clause in load script

juliensaintmaxent3113 — Mon, 28 Jan 2019 10:15:29 GMT

hi,

your table has got data ?

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

tblconfirmed.qvd (qvd)

Bye

Re: table storing error when using if clause in load script

madushanfernand — Mon, 28 Jan 2019 11:33:14 GMT

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.