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

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

Thu, 06 Feb 2014 16:55:46 GMT

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;

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

Nicole-Smith — Thu, 06 Feb 2014 17:01:06 GMT

ResultTable:

NOCONCATENATE LOAD * Resident InputTable;

Inner Join LOAD * resident InputTable2;

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

Thu, 06 Feb 2014 17:13:42 GMT

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

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

Thu, 06 Feb 2014 17:16:04 GMT

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

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

Thu, 06 Feb 2014 17:16:54 GMT

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

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

Nicole-Smith — Thu, 06 Feb 2014 17:18:46 GMT

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.

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

Thu, 06 Feb 2014 17:24:48 GMT

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

regards

Mahesh T

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

Thu, 06 Feb 2014 17:26:50 GMT

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

regards

Mahesh T

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

Fri, 07 Feb 2014 08:59:00 GMT

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

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

Fri, 07 Feb 2014 13:03:23 GMT

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?

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

nizamsha — Fri, 07 Feb 2014 13:10:49 GMT

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

];

NoConcatenate

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

];

NoConcatenate

ResultTable:

LOAD * Resident InputTable;

Inner Join LOAD * resident InputTable2;

DROP Tables InputTable,InputTable2;

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

Fri, 07 Feb 2014 13:20:09 GMT

QV still crashes....

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

Fri, 07 Feb 2014 13:26:02 GMT

end with InputTable2 54 lines fetched

and crashes QV

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

sunilkumarqv — Fri, 07 Feb 2014 13:41:39 GMT

make Right keep instead of innerjoin

ResultTable:

LOAD * Resident InputTable;

Right keep LOAD * resident InputTable2;

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

Fri, 07 Feb 2014 13:46:36 GMT

Still crashes....

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

Nicole-Smith — Fri, 07 Feb 2014 13:52:08 GMT

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

];

and

ResultTable:

LOAD * Resident InputTable;

the column names are equal; hence, it concatenating the tables together.

If you want help with it crashing, you're going to need to post a .qvw file.

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

Fri, 07 Feb 2014 13:57:27 GMT

Ok it concatenates.

So to understand better after:

ResultTable:

LOAD * Resident InputTable;

InputTable gets:

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

'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

and ResultTable gets empty, right?

And what happens to these 2 tables on the inner join?

I'm working on the QVW to post here without sensitive data.

Thanks,

Miguel

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

Nicole-Smith — Fri, 07 Feb 2014 14:02:48 GMT

Miguel Domingos wrote:

Ok it concatenates.

So to understand better after:

ResultTable:

LOAD * Resident InputTable;

InputTable gets:

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

'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

and ResultTable gets empty, right?

Correct. ResultTable is never created since it just concatenates the data onto InputTable causing the number of lines to double (each line has a duplicate).

Miguel Domingos wrote:

And what happens to these 2 tables on the inner join?

My guess is the inner join is inner joining InputTable2 to itself resulting in the same data as the original.

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

martinpohl — Fri, 07 Feb 2014 14:03:56 GMT

Why using a temporary table.

Youn can load the data in 2 steps:

ResultTable:

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

];

inner join 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

];

the input tables are not used.

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

juleshartley — Fri, 07 Feb 2014 14:04:11 GMT

it's probably crashing because it's trying to join across many fields (ie. create a vast synthetic key). Try 'Qualify *' to investigate what is going on and see if it doesn't crash...