topic Issues With NOCONCATENATE in QlikView

Issues With NOCONCATENATE

Thu, 19 Jan 2012 10:55:19 GMT

Hi all,

I have attached qlikview file in which i pull data from table t1 using resident to table t2. I used noconcatenate because i am pulling same copy of data.

Whenever I want to view the data in t1 and t2 in internal table view, by rirght clicking on table, and then clicking on data, the qlikview application file is getting struck, however no problem in front end. Can anyone come about this clearly?

Thanks,

Murali

Issues With NOCONCATENATE

jagannalla — Thu, 19 Jan 2012 11:05:45 GMT

Check this..

t1:

Load * inline [a,b,c

1,2,3];

t2:

NoConcatenate

Load * resident t1;

Issues With NOCONCATENATE

Thu, 19 Jan 2012 11:27:39 GMT

Thanks Jagan,

Still same problem exists for t1 and t2, not for synTable.

Re: Issues With NOCONCATENATE

Miguel_Angel_Baeyens — Thu, 19 Jan 2012 11:27:46 GMT

Hi Murali,

There are a couple of things here. One is the version of QlikView you are using. That was a known issue (registered as bug ID 24386 crashing when right clicking on the table viewer when synthetic keys are in the data model) in some release of version 9 SR6 under some circumstances. I don't know if the problem still persists in version 10. As far as I'm concerned, I can open your file and see the tables and the synthetic table without crashes.

Second is that the synthetic table that is created after the load is bound to be unwanted, so to avoid it, add below the script the line

t1:
Load * inline [a,b,c
1,2,3];
Noconcatenate
t2:
Load * resident t1;
DROP TABLE t1;

That will remove from memory table "t1" leaving only "t2". There shouldn't be any crash now.

Hope that helps.

Miguel

EDIT: I forgot to mention, regarding the first point, to update to the latest release of QlikView (version 10 SR4 build 9282 or version 9 SR7 7778). Updated with the bug info.

Issues With NOCONCATENATE

Thu, 19 Jan 2012 11:32:14 GMT

Many Thanks Miguel..

I am using v9....