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


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




  • Re: concatenate

    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



    load * from abc.qvd (qvd);


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


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