Combining files

[#1]

I have 2 csv files. One contains headers to the other file data. How do I combine both the files into a single QVD in Qlikview?

[#2]

Hi this resolved my issue.

Thanks

[MarcoWedel]

Hi,

another example (using arumamahesh's sample data) without the need to manually define column names as aliases in the script (thus rendering the header table useless):

tabHeaders:
CrossTable (ColNam, ColVal)
LOAD 1, * From [https://community.qlik.com/servlet/JiveServlet/download/1156762-252995/Sample.xlsx] (ooxml, no labels, table is Sheet1);

mapHeaders:
Mapping LOAD ColNam, ColVal Resident tabHeaders;

DROP Table tabHeaders;

tabData:
LOAD * From [https://community.qlik.com/servlet/JiveServlet/download/1156762-252995/Sample.xlsx] (ooxml, no labels, table is Sheet2);

RENAME Fields using mapHeaders;

hope this helps

regards

Marco