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

[#1]

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;

[Nicole-Smith]

ResultTable:

NOCONCATENATE LOAD * Resident InputTable;

Inner Join LOAD * resident InputTable2;

[#3]

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

[#4]

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

[#5]

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

[Nicole-Smith]

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.

[#7]

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

regards

Mahesh T

[#8]

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

regards

Mahesh T

[#9]

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

[#10]

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?