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;

[#2]

with:

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

];

qualify *;

ResultTable:

noconcatenate LOAD * Resident InputTable;

Inner Join LOAD * resident InputTableRU;

I get the 4 tables in the attached image and doesn't crash.

Strange names on ResutTable for column names coming from the second table...

[Nicole-Smith · Accepted solution]

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;