Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Why ResultTable doesn't show up on File->Table Viewer?

Smal example:

InputTable:

LOAD * INLINE [

  MDate, Contract_ID,Attribute_Name,Attribute_Value_Text

  '2012-05-22 17:21:22.111', ball,color,red

  '2012-05-22 17:21:22.111', ball,diameter,10 cm

  '2012-05-22 17:21:22.111', ball,weight,100 g

  '2014-05-23 17:21:22.111', box,color,black

  '2014-05-23 17:21:22.111', box,height,16 cm

  '2014-05-23 17:21:22.111', box,length,20 cm

  '2014-05-23 17:21:22.111', box,weight,500 g

  '2014-05-23 17:21:22.111', box,width,10 cm

];

InputTable2:

LOAD * INLINE [

  MDate, Contract_ID,Attribute_Name2,Attribute_Value_Text2

  '2012-05-22 17:21:22.111', ball,color,red

  '2012-05-22 17:21:22.111', ball,diameter,10 cm

  '2012-05-22 17:21:22.111', ball,weight,100 g

  '2014-05-23 17:21:22.111', box,color,black

  '2014-05-23 17:21:22.111', box,height,16 cm

  '2014-05-23 17:21:22.111', box,length,20 cm

  '2014-05-23 17:21:22.111', box,weight,500 g

  '2014-05-23 17:21:22.111', box,width,10 cm

];

ResultTable:

LOAD * Resident InputTable;

Inner Join LOAD * resident InputTable2;

Tags (2)
1 Solution

Accepted Solutions

Re: Re: Why ResultTable doesn't show up on File->Table Viewer?

Julian Hartley is correct about it probably creating synthetic keys.  Once you add the input tables into the result tables, you should drop the two original tables to avoid the synthetic keys.  Maybe this will keep it from crashing:

InputTable:

LOAD * INLINE [

  MDate, Contract_ID,Attribute_Name,Attribute_Value_Text

  '2012-05-22 17:21:22.111', ball,color,red

  '2012-05-22 17:21:22.111', ball,diameter,10 cm

  '2012-05-22 17:21:22.111', ball,weight,100 g

  '2014-05-23 17:21:22.111', box,color,black

  '2014-05-23 17:21:22.111', box,height,16 cm

  '2014-05-23 17:21:22.111', box,length,20 cm

  '2014-05-23 17:21:22.111', box,weight,500 g

  '2014-05-23 17:21:22.111', box,width,10 cm

];

InputTableRU:

LOAD * INLINE [

  MDate, Contract_ID,Attribute_Name2,Attribute_Value_Text2

  '2012-05-22 17:21:22.111', ball,color,red

  '2012-05-22 17:21:22.111', ball,diameter,10 cm

  '2012-05-22 17:21:22.111', ball,weight,100 g

  '2014-05-23 17:21:22.111', box,color,black

  '2014-05-23 17:21:22.111', box,height,16 cm

  '2014-05-23 17:21:22.111', box,length,20 cm

  '2014-05-23 17:21:22.111', box,weight,500 g

  '2014-05-23 17:21:22.111', box,width,10 cm

];

ResultTable:

noconcatenate LOAD * Resident InputTable;

Inner Join LOAD * resident InputTableRU;

DROP TABLES InputTable, InputTableRU;

21 Replies

Re: Why ResultTable doesn't show up on File->Table Viewer?

ResultTable:

NOCONCATENATE LOAD * Resident InputTable;

Inner Join LOAD * resident InputTable2;

Not applicable

Re: Why ResultTable doesn't show up on File->Table Viewer?

Hi Miguel,

Qlikview concatenates two tables ,  if  two tables has same no of fields and same fields.so use NOCONCATENATE  then it is treated as two tables.

am i right @ NIcol.

regards

Mahesh T

Not applicable

Re: Why ResultTable doesn't show up on File->Table Viewer?

But why is it concatenating, if the 2 tables have different column names?

Not applicable

Re: Why ResultTable doesn't show up on File->Table Viewer?

But why is it concatenating, if the 2 tables have different column names?

Re: Why ResultTable doesn't show up on File->Table Viewer?

When you're doing the first load for ResultTable, that has the exact same column names as InputTable because you're loading in * with the names that already exist.

Not applicable

Re: Why ResultTable doesn't show up on File->Table Viewer?

Same field names and same no of fileds as well.first input table from inline is same as first resident.

regards

Mahesh T

Not applicable

Re: Why ResultTable doesn't show up on File->Table Viewer?

if you are fine with answers then close the thread with correct answer helpful to others.

regards

Mahesh T

Not applicable

Re: Why ResultTable doesn't show up on File->Table Viewer?

Sorry to be pedantic, but column names as I see it are different:

MDate, Contract_ID,Attribute_Name,Attribute_Value_Text

equals    equals         not equal                     not equal

MDate, Contract_ID,Attribute_Name2,Attribute_Value_Text2


Thanks,

Miguel

Not applicable

Re: Why ResultTable doesn't show up on File->Table Viewer?

Another strange thing is that with this small example the NOCONCATENATE works, but loading 5000 rows from a database at the end of the script QlikView crashes....

Any help?