Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-02-06 11:55 AM

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;

1,390 Views
21 Replies
nizamsha
Specialist II
Specialist II
‎2014-02-07 08:10 AM

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;

360 Views
0 Likes
Not applicable
‎2014-02-07 08:20 AM
Author

In response to nizamsha

QV still crashes....

360 Views
0 Likes
Not applicable
‎2014-02-07 08:26 AM
Author

In response to nizamsha

end with InputTable2 54 lines fetched

and crashes QV

360 Views
0 Likes
sunilkumarqv
Specialist II
Specialist II
‎2014-02-07 08:41 AM

In response to

make Right keep instead of innerjoin

ResultTable:

LOAD * Resident InputTable;

Right keep LOAD * resident InputTable2;

Test.qvw
360 Views
0 Likes
Not applicable
‎2014-02-07 08:46 AM
Author

In response to sunilkumarqv

Still crashes....

360 Views
0 Likes
Nicole-Smith
MVP
MVP
‎2014-02-07 08:52 AM

In response to

In

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.

360 Views
Not applicable
‎2014-02-07 08:57 AM
Author

In response to Nicole-Smith

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

360 Views
0 Likes
Nicole-Smith
MVP
MVP
‎2014-02-07 09:02 AM

In response to

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.

360 Views
martinpohl
Partner - Master
Partner - Master
‎2014-02-07 09:03 AM

In response to

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.

360 Views
0 Likes
juleshartley
Specialist
Specialist
‎2014-02-07 09:04 AM

In response to


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...

360 Views