topic Re: Missing rows after server reload in QlikView

Missing rows after server reload

salto — Tue, 30 Dec 2014 09:23:28 GMT

Hello all,

I am facing a problem I am not able to understand: I am concatenig several rows from another table to the Fatcs table, something like:

Extra_Data:

concatenate (FactsTable)

Load *, ....

This works perfectly when I am developing the document and when I reload it from QlikView Desktop. But, when the document is saved and opened back (no matter if it is in Qv Desktop or in the QlikView Server), the rows under Extra_Data have disappeared - over and over again.

Could anyone let me know what a I doing wrong?

Many thanks!

Re: Missing rows after server reload

Tue, 30 Dec 2014 09:26:26 GMT

when the table Extra_Data: is in the script pls try when you remove/comment it. Why do you need it ?

cheers

Re: Missing rows after server reload

salto — Tue, 30 Dec 2014 11:31:52 GMT

Hello,

the Extra_Data table has rows I would like to abe added to the Facts table.

When I load the document manually in QV desktop, the rows appear. But when I save & close the document, and open it again, they do not appear anymore. Honestly I cannot find an explanation to this. Does anyone have faced this issue?

Thanks!

Re: Missing rows after server reload

Tue, 30 Dec 2014 11:36:29 GMT

Hi Salto,

do you have any section access within the application which is reducing the data down?

Re: Missing rows after server reload

salto — Tue, 30 Dec 2014 11:38:56 GMT

Hello joe,

After browsing similar past queries in the community I was considering that option right now - Will let you know! Thank you.

Re: Missing rows after server reload

Tue, 30 Dec 2014 11:45:24 GMT

No worries glad to be of help, let me know the outcome!

Re: Missing rows after server reload

Tue, 30 Dec 2014 11:51:26 GMT

okay, but pls check your script again... concatenating would have a syntax like the following:

Fact_Table: NoConcatenate

load * resident Table1;

Concatenate(Fact_Table)

load * resident Table2;

table 1 and 2 are now in the Fact_Table

hope it helps you

cheers

Re: Missing rows after server reload

salto — Tue, 30 Dec 2014 12:53:47 GMT

The problem was just that - now it is showing all the records! Seems so basic question now!

Thanks a lot.

Re: Missing rows after server reload

salto — Tue, 30 Dec 2014 12:54:55 GMT

Hi Felix,

thank you - the concatenation syntax is correct in my script, the issue ws the data reduction I was not considering.

Cheers!

Re: Missing rows after server reload

Tue, 30 Dec 2014 13:03:33 GMT

Ah good stuff, glad it's sorted now

Re: Missing rows after server reload

Tue, 30 Dec 2014 13:07:35 GMT

haha ok! nice it's solved... the devil is in the detail....

Re: Missing rows after server reload

Sowmya05 — Thu, 31 Jan 2019 11:07:34 GMT

Where is the solution?