loosen table script

[#1]

Hi community!!

I´m studing some doubts I have and its apllications. Currently, I have a problem with qlikview reference manual´s loosen table statement example:

I mix exampple on page 160 with statement explined on page 326, but something is wrong and I do´t know what what it should be. Here you are my
senteces on the script.

LOAD YEAR,
DATE
FROM (biff, embedded labels, table is Hoja1$);

LOAD DATE,
PROD,
AMOUNT
FROM (biff, embedded labels, table is Hoja2$);

LOAD PROD,
PRODGRP
FROM (biff, embedded labels, table is Hoja3$);

Hoja2$:
SELECT *
FROM (biff, embedded labels, table is Hoja2$);
LOOSEN TABLE Hoja2$;

I hope someone could help me.

Thanks, Fiber9906

[#2]

Hi,

I am reviewing doubts and I always have same problem. Every example on the tutorial are like

select * from table3

but I create my examples on excel, so my table is (biff, embedded labels, table is sheet2$);

I said that because if I load by inline statement everything is fine, but all documents I´ve got are excel, access queries or txt.

Could anyone help me?

Thanks! Fiber 9906 ; )

[tresesco]

Hi, your issue is not clear to me. when you load using INLINE, there is no issue, but when loading from excel then there is probably an issue. what is that? Regards, tresesco

[#4]

You are right, I mixed two different problems. I apologize. Nevertheless, I upload a file with my script problem. Can you help me?

Thanks, Fiber9906

[tresesco]

Instead of SELECT use LOAD in the commented part.when you use SELECT QV expects an ODBC-type connection. as you are fetching the data directly from excel with no ODBC connection, go simply with LOAD command.

Hope this helps.

Regards, tresesco

[#6]

Hi tresesco,

Thank you for answer me. I´d tried this before, but pivot table result isn´t right, beacuse every prodgrp sum(amount)=108. I must be mistaked in other thing. What it should be?

Thanks, Fiber9906

[tresesco]

Hi,

i will have to go through your application again(can't do it now). and yes i don't know the values of your excel. can you just upload the excels as well?

Regards, tresesco

[#8]

Hi don´t worry if you can´t do it know. I attach you excel file.

Thanks!!

[#9]

Hi to all!!

I remember that post. Anyone can help me?

Thanks. Fiber9906

[#10]

Hello Fiber,

use LOAD instead of SELECT. Thats all. As tresesco mentioned above "Select" is for SQL-Statements.

Regards, Roland