Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
junasharma
Creator
Creator

Concatenate

Hi All,

I was trying to concatenate to fact tables from datamart but I am getting error for the same in Qliksense.

  SQL SELECT * from (select * from "Table A") CONCATENATE (select * from "Table B");

Could you please help me with this?

Thanks

in advance

7 Replies
sasiparupudi1
Master III
Master III

SQL SELECT * from (select * from "Table A")

CONCATENATE

SQL select * from "Table B"

junasharma
Creator
Creator
Author

I did that but got general oledb error.

sasiparupudi1
Master III
Master III

may be try

SQL select * from "Table A"

CONCATENATE

SQL select * from "Table B"

jayanttibhe
Creator III
Creator III

Table:

SQL SELECT  *

  FROM sqlServer_Table1

;

Concatenate

SQL SELECT  *

  FROM sqlServer_Table2

;

jayanttibhe
Creator III
Creator III

remember in the script using SQL statement  -  the SQL area STARTs and ENDs  as  highlighted below.

Between RED (sql ) colored  area is SQL specific.  Your qlik functions wont work there.

The mentioned in BLUE is qlik function. so you should not interfere between these 2 in qlik script.

Table:

SQL SELECT  *

  FROM sqlServer_Table1

;

Concatenate

SQL SELECT  *

  FROM sqlServer_Table2

;

juriengroot
Contributor III
Contributor III

If you want to do it just in SQL status, you should using UNION ALL with matching columns.

SQL SELECT * from (select * from "Table A") UNION ALL(select * from "Table B");


This should work.

sasiparupudi1
Master III
Master III

Did you manage to solve this problem?