concatenate

[#1]

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

[Gysbert_Wassenaar]

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)

[#3]

Hey

you must be right, after copying the column names from the top it worked. Thank you

regards,

MT