topic Re: LOAD with SQL SELECT fails in QlikView

LOAD with SQL SELECT fails

Thu, 26 Jul 2012 20:45:16 GMT

I have several problems when I load a table.

The script is this:

QUALIFY*;
Movim:  
LOAD
    FE_MOV,
    VOUCHER,
    CG_ASIEN,
     .
     .
     .  
    CAE_PRODUCCION,
    CAE_TESTING,
    MONEDA3;
SQL SELECT * 
FROM dbo_Movim;
STORE * from dbo_Movim into $(QvdPath)Movim.qvd (qvd);

Problems:

The table is not named as "Movim" (so when I use STORE, use "from dbo_Movim")
Unrecognized statement 'Qualify': it doesn´t work.
Can´t STORE the table into qvd format.

If I remove the STORE statement then load the table but unqualified.

Re: LOAD with SQL SELECT fails

MayilVahanan — Thu, 26 Jul 2012 20:54:56 GMT

Try like this,

Movim:

LOAD

FE_MOV,

VOUCHER,

CG_ASIEN,

CAE_PRODUCCION,

CAE_TESTING,

MONEDA3;

SQL SELECT *

FROM dbo_Movim;

Then reload it , and see the result..

Store Movim into Testing.qvd(qvd);

Re: LOAD with SQL SELECT fails

nagaiank — Thu, 26 Jul 2012 20:55:26 GMT

Try the following:

QUALIFY *; Movim: LOAD FE_MOV, VOUCHER, CG_ASIEN, . . . CAE_PRODUCCION, CAE_TESTING, MONEDA3; SQL SELECT * FROM dbo_Movim; STORE Movim into $(QvdPath)Movim.qvd (qvd);

Re: LOAD with SQL SELECT fails

Fri, 27 Jul 2012 13:23:35 GMT

It still does not work.

When the script is the next, I get the table but unqualified:

**************************************************************************

QUALIFY *;

Movim:

LOAD

FE_MOV,

VOUCHER,

CG_ASIEN,

CAE_PRODUCCION,

CAE_TESTING,

MONEDA3;

SQL SELECT *

FROM dbo_Movim;

**************************************************************************

And if I add the STORE clause (STORE Movim into $(QvdPath)Movim.qvd (qvd);), the script doesn not run.

Re: LOAD with SQL SELECT fails

Fri, 27 Jul 2012 13:35:02 GMT

First all field names in load statement should be upper , and then check if any field is repeating.in second case there is a chance to reload fail.

Re: LOAD with SQL SELECT fails

Fri, 27 Jul 2012 14:27:03 GMT

Problem solved, was missing a comma after the definition of QvdPath

Thank you all.