4 Replies Latest reply: Jul 15, 2014 9:48 AM by Martin Pohl RSS

    Table not found?

    Matt Maino

      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

      [C:\Development\SpecificLoans.xlsx]

      (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?
          Avinash R

          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?
            Alessandro Saccone

            Try this and let me know:

             

            SpecificLoans:

            LOAD

                 [Loan Number] as acct_nbr

            FROM

            [C:\Development\SpecificLoans.xlsx]

            (ooxml, embedded labels, table is Sheet1);

             

            Left Join (SpecificLoans)

            LOAD*

            Resident Loans;

            • Re: Table not found?
              pradeep t

              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?
                Martin Pohl

                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

                [C:\Development\SpecificLoans.xlsx]

                (ooxml, embedded labels, table is Sheet1);

                 

                temp:

                noconcatenate

                LOAD *

                Resident Loans

                where exists ([Loan Number],acct_nbr);

                 

                drop table Loans;

                drop table SpecificLoans;