6 Replies Latest reply: Oct 10, 2011 7:33 AM by Chris Hopkins RSS

    Change table name

      I'm a newbie in Qlikview and need some help.

       

       

      How do I change the name of the table so I don't need to see the name "Sheet1" in the table after completed reloading the script code?

       

      The code is:

       

      Directory;

      LOAD

           A,

           B,

           C,

           D

      FROM

      Downloads\test.xls

      (biff, embedded labels, table is Sheet1$);

       

      // Fullmetalboy

        • Change table name
          Anand Chouhan

          Hi,

           

           

          Give your choice table name in above the load code like see the code

           

          YourTableName:   <--Your table name goes here.

          LOAD

               A,

               B,

               C,

               D

          FROM

          Downloads\test.xls

          (biff, embedded labels, table is Sheet1$);

           

          Rgds

          Anand

          • Change table name

            Hi,

             

            you con add the tablename before the LOAD. In your case:

             

            tablename:

            Directory;

            LOAD

                 ...

             

            The tablename has to be one word, otherwise you have to use [name of table].

             

            Regards

            vicky

            • Change table name
              Anand Chouhan

              Hi,

               

              Hope you got correct answer with this if so mark it correct or help ful so other can see it.

               

              Rgds

              Anand

              • Change table name
                Kamal Naithani

                Hi Jimmy....you can do like this....

                TableName:                            (in case table name is of one word)

                or

                [Table Name]                           (in case you are using more than one word)

                LOAD

                     A,

                     B,

                     C,

                     D

                FROM

                Downloads\test.xls

                (biff, embedded labels, table is Sheet1$);

                 

                 

                hope this will help you

                • Change table name
                  Chris Hopkins

                  Hi, all you need to do is instead of using Directory; , use your table name but instead of the semi colon (;), use colon(:)

                   

                   

                  TableName:

                  LOAD

                       A,

                       B,

                       C,

                       D

                  FROM

                  Downloads\test.xls

                  (biff, embedded labels, table is Sheet1$);