Union of two tables in Qlik Sense

[dradoikov]

Hi,

I'm trying to do a UNION of two QVD tables with exatly the same fields in Qlik Sense. In QlikView it is done automatically. I also tried the functuion CONCATENATE, but it also does not work. The error is:BuildErrorForVMap: Internal Error occurred in call to vMap function; calling function: void CTable::LoadQvc.

Is there any soution?

Thanks

[dradoikov]

Hi Jagan,

I have also tired it with Concatenate(Data), but it still gives the same result with and without giving the full path for the files.

[jagan]

Hi,

The below script works for me use WHERE 1=1 for QVD loading, it is working correctly.

mto

please check this, seems to be a bug, attached the sample files which I used.

Table1:

LOAD

    ID,

    value

FROM 'lib://Apps/data.xlsx'

(ooxml, embedded labels, table is Sheet1);

STORE Table1 INTO 'lib://Apps/Table1.qvd';

DROP TABLE Table1;

Table2:

LOAD

    ID,

    value

FROM 'lib://Apps/data.xlsx'

(ooxml, embedded labels, table is Sheet2);

STORE Table2 INTO 'lib://Apps/Table2.qvd';

DROP TABLE Table2;

Data:

LOAD

ID,

value

FROM 'lib://Apps/Table1.qvd'

(qvd)

WHERE 1=1;

LOAD

ID,

value

FROM 'lib://Apps/Table2.qvd'

(qvd)

WHERE 1=1;

[Michael_Tarallo · Accepted solution]

Hi Jagan,

I confirmed this behavior - and reported it - it seems that when the .qvd files are created with Sense in this manner, it does not work as expected.

Mike

[jagan]

Hi Micheal/Daniel,

Please close this thread, so that it helps others to find the solution for similiar issues.

Regards,

Jagan.

[mbjallow6]

Hello Jagan! Could yu place expalin the Drop table syntax. because to my little understanding of SQL, Drop table means to delete the table and its content. therefore, in qlik sense, if you drop table and table 2, hw can one load to the Data table?