topic Re: Table not found? in QlikView

Table not found?

Tue, 15 Jul 2014 13:37:54 GMT

Hi everyone,

I am trying to import a table from excel that contains only one field called acct_nbr. Then I am trying to left join a table that I already have in qlikview called Loans (with several fields) to that table with one field. The Loans table that I already have in qlikview has a field called acct_nbr, but with more entries than the excel table. My goal in left joining to the excel table is to omit those rows in the Loans table that do not share an Account Number with the excel table. For some reason my logic is not working for this. (shown below) I am getting an error that the table can not be found. Anybody know that I'm doing wrong? Thanks.

SpecificLoans:

LOAD

[Loan Number] as acct_nbr

FROM

(ooxml, embedded labels, table is Sheet1);

temp:

Left Join (SpecificLoans)

LOAD*

Resident Loans;

Drop table SpecificLoans;

Rename table temp to SpecificLoans;

Re: Table not found?

avinashelite — Tue, 15 Jul 2014 13:43:46 GMT

Hi Matthew,

your dropping SpecificLoans table. After joining the data gets append to the first table name so here its getting append to SpecificLoans table and your droping the same hence your getting the error.

Re: Table not found?

alexandros17 — Tue, 15 Jul 2014 13:44:30 GMT

Try this and let me know:

SpecificLoans:

LOAD

[Loan Number] as acct_nbr

FROM

(ooxml, embedded labels, table is Sheet1);

Left Join (SpecificLoans)

LOAD*

Resident Loans;

Re: Table not found?

PradeepReddy — Tue, 15 Jul 2014 13:48:30 GMT

When you are doing left join.. all the data will be append to the left Table.

In Your case,

Your joining the 'temp' table with 'SpecificLoans' table. Then the result will be stored in 'SpecificLoans' and

'temp' table no more exits. After that you are renaming the 'temp' table which is not exists.

So you got the error 'Table not Found'.

Re: Table not found?

martinpohl — Tue, 15 Jul 2014 13:48:38 GMT

You join the table temp to the table SpecificLoans, so there is not table temp to rename.

If you only want to load thoses datas which are in the excel file load

SpecificLoans:

LOAD

[Loan Number]

FROM

(ooxml, embedded labels, table is Sheet1);

temp:

noconcatenate

LOAD *

Resident Loans

where exists ([Loan Number],acct_nbr);

drop table Loans;

drop table SpecificLoans;