2 Replies Latest reply: Feb 21, 2013 3:36 AM by Magdalena Tammegger RSS

    concatenate

    Magdalena Tammegger

      Hi I want to create a table in qv and I have 3 excel files I want to concatenate but it always ignore the last excel file it just doesnt do a concatenate load.

      does anyone know why??

       

      please help me

       

      regards,

      MT

        • Re: concatenate
          gwassenaar

          Probably because the field names and number of fields aren't exactly the same. QV is case sensitive so a capital letter can make a field name different. You can force concatenating by using the concatenate keyword in front of load

           

          T1:

          load * from abc.qvd (qvd);

           

          concatenate (T1) load * from cde.qvd (qvd);

           

          (works the same for excel files in case you're wondering)