Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
SQL SELECT * from (select * from "Table A")
CONCATENATE
SQL select * from "Table B"
I did that but got general oledb error.
may be try
SQL select * from "Table A"
CONCATENATE
SQL select * from "Table B"
Table:
SQL SELECT *
FROM sqlServer_Table1
;
Concatenate
SQL SELECT *
FROM sqlServer_Table2
;
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
;
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.
Did you manage to solve this problem?