6 Replies Latest reply: Aug 2, 2011 9:49 AM by JAMESPAR RSS

    Loading query

      Hi All,

       

      I need to load multiple data tables containing the same fields, each for a different client, example below:

       

      ClientAAAA
      DateBalanceFee
      23-May50100
      24-May60120
      25-May100200
      26-May50100
      27-May4080
      28-May100200
      29-May50100

       

      Anyone know of a way when loading of adding the client name to each row of data in the table without having to go into each sheet and adding an additional 'client' column as below?

       

      ClientAAAA
      ClientDateBalanceFee
      AAAA23-May50100
      AAAA24-May60120
      AAAA25-May100200
      AAAA26-May50100
      AAAA27-May4080
      AAAA28-May100200
      AAAA29-May50100

       

      thanks in advance,

       

      James

        • Loading query
          Rahul Gupta

          Hey hi,

           

          Just Use the Code as follows:

           

          Load *,

                  'AAAA' as ClientName

          From Table;

           

          Load*,

                 'BBBB' as ClientName

          From Table;

           

          and so on..........

           

          Hope this helps...         

           

          Regards

          • Re: Loading query

            You can see in the blog community Toccato. I posted about it today. Only in Portuguese.

             

            Blog Toccato

             

            Best Regards.

            Tonial.

              • Re: Loading query

                Thanks for the responses.  Unfortunately I am unable to access the linked blog.

                 

                My initial question was a little unclear, so I will clarify what I am trying to achieve.

                 

                I have multiple spreadsheets each for a different client in the following format:

                 

                Client

                AAAA
                DateBalanceFee
                23-May50100
                24-May60120
                25-May100200
                26-May50100
                27-May4080
                28-May100200
                29-May50100

                 

                I am looking for some code that will pick up the client in cell B1 and produce a Qlikview table as follows:

                 

                ClientDateBalanceFee
                AAAA23-May50100
                AAAA24-May60120
                AAAA25-May100200
                AAAA26-May50100
                AAAA27-May4080
                AAAA28-May100200
                AAAA29-May50100

                 

                Thanks again,

                 

                James