Concatenate

[Anonymous]

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

[sasiparupudi1]

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

CONCATENATE

SQL select * from "Table B"

[Anonymous]

I did that but got general oledb error.

[sasiparupudi1]

may be try

SQL select * from "Table A"

CONCATENATE

SQL select * from "Table B"

[jayanttibhe]

Table:

SQL SELECT  *

  FROM sqlServer_Table1

;

Concatenate

SQL SELECT  *

  FROM sqlServer_Table2

;

[jayanttibhe]

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]

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]

Did you manage to solve this problem?