How to excell sheets convert to single QVD

[beyhur_kaya]

I have five excell sheet.I want to convert them into a single qvd.it gives me error when I write code.

Table1: 

LOAD * 

FROM [01.11.2016 KRC HAM KUMAŞ.xlsx]

(ooxml, embedded labels, table is [BASKI DETAY]);

JOIN LOAD * 

FROM [01.11.2016 KRC HAM KUMAŞ.xlsx]

(ooxml, embedded labels, table is [BASKI ÖZET]);

JOIN LOAD *  

FROM [01.11.2016 KRC HAM KUMAŞ.xlsx]

(ooxml, embedded labels, table is [HAM KMŞ DTY]);

Join LOAD *

From  [01.11.2016 KRC HAM KUMAŞ.xlsx]

(ooxml, embedded labels, table is [HAM KMŞ ÖZET]);

Join LOAD *

FROM [01.11.2016 KRC HAM KUMAŞ.xlsx]

(ooxml, embedded labels, table is [ÖZET KUMAŞ]);

STORE Table1 INTO C:\..\...\Documents\QlikViewExamples\FileAll.qvd;

Gives error table not found.

[bohravanraj]

Try below Code

Table1:

LOAD *

FROM [01.11.2016 KRC HAM KUMAŞ.xlsx]

(ooxml, embedded labels, table is [BASKI DETAY]);

Concatenate(Table1)

LOAD *

FROM [01.11.2016 KRC HAM KUMAŞ.xlsx]

(ooxml, embedded labels, table is [BASKI ÖZET]);

Concatenate(Table1)

LOAD * 

FROM [01.11.2016 KRC HAM KUMAŞ.xlsx]

(ooxml, embedded labels, table is [HAM KMŞ DTY]);

Concatenate(Table1)

LOAD *

From  [01.11.2016 KRC HAM KUMAŞ.xlsx]

(ooxml, embedded labels, table is [HAM KMŞ ÖZET]);

Concatenate(Table1)

LOAD *

FROM [01.11.2016 KRC HAM KUMAŞ.xlsx]

(ooxml, embedded labels, table is [ÖZET KUMAŞ]);

STORE Table1 INTO C:\..\...\Documents\QlikViewExamples\FileAll.qvd;