Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

concatenate

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

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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)


talk is cheap, supply exceeds demand
Not applicable
Author

Hey

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

regards,

MT