topic How to excell sheets convert to single QVD in QlikView

How to excell sheets convert to single QVD

beyhur_kaya — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 01 Nov 2016 16:05:34 GMT

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;