Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

LOAD with SQL SELECT fails

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:

  1. The table is not named as "Movim" (so when I use STORE, use "from dbo_Movim")

  2. Unrecognized statement 'Qualify': it doesn´t work.

  3. Can´t STORE the table into qvd format.

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

1 Solution

Accepted Solutions
Not applicable

Re: LOAD with SQL SELECT fails

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

Thank you all.

5 Replies

Re: LOAD with SQL SELECT fails

HI

     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);

nagaiank
Valued Contributor III

Re: LOAD with SQL SELECT fails

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);

Not applicable

Re: LOAD with SQL SELECT fails

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)Smiley Wink, the script doesn not run.

Not applicable

Re: LOAD with SQL SELECT fails

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.

Not applicable

Re: LOAD with SQL SELECT fails

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

Thank you all.

Community Browser