Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Table not found?

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;

4 Replies

Re: Table not found?

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?

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;

pradeepreddy
Valued Contributor II

Re: Table not found?

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'.

martinpohl
Valued Contributor II

Re: Table not found?

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;

Community Browser