topic i can't do a join in QlikView

i can't do a join

magdagarcia — Tue, 19 Mar 2013 15:15:38 GMT

when i try to do a join appear the next error;

for example;

table_name_X:

LOAD

field1 as fiedtojoin,

field2,

field3

from table1

outer join

LOAD

field1 as fiedtojoin,

field3,

field4

from table1

store table_name_X INSERT table_name_store.qvd

ERROR:

no found the table called: table_name_X

BUT when i disable the sentence: //store table_name_X INSERT table_name_store.qvd

work it

Some Any IDEA??

Regards!!!

Re: i can't do a join

alexandros17 — Tue, 19 Mar 2013 15:25:09 GMT

If I'm not wrong the sysntax is

Store Table INTO .....

Re: i can't do a join

Tue, 19 Mar 2013 15:25:11 GMT

Your store stament is wrong. use store like below.

STORE MyTableName into $(Directory)$(vMyTableName).qvd;

Re: i can't do a join

magdagarcia — Thu, 21 Mar 2013 16:16:26 GMT

Hi KStrak S and alexandros17good moorning thanks for you response but the query Actually is done on this way:

BUT THANKS VERY MUCH FOR YOUR HELP!!!

GPS_Quotes_Users_Final:

LOAD quote_number,
LastModifiedDate
FROM
Dimensiones\GPS_Quotes_Users2.qvd
(qvd);

Left Join

LOAD

     quote_number,
     customer_name,
     reference,
     abandon_reason,
     actual_close_date,
     yearClosed,
     monthClosed,
     dayClosed,
     actual_quote_submitted_date,
     month_actual_quote,
     year_actual_quote,
     day_actual_quote,
     gps_currency,
     yearDue,
     monthDue,
     dayDue

n...FIELDS.....

FROM
Dimensiones\GPS_Quotes_Users.qvd
(qvd);
STORE GPS_Quotes_Users_Final INTO Dimensiones\GPS_Quotes_Users_Final.qvd;

drop Table GPS_Quotes_Users_Final;