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)