Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

junasharma
Contributor

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
Honored Contributor III

Re: Concatenate

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

CONCATENATE

SQL select * from "Table B"

junasharma
Contributor

Re: Concatenate

I did that but got general oledb error.

sasiparupudi1
Honored Contributor III

Re: Concatenate

may be try

SQL select * from "Table A"

CONCATENATE

SQL select * from "Table B"

jayanttibhe
Contributor II

Re: Concatenate

Table:

SQL SELECT  *

  FROM sqlServer_Table1

;

Concatenate

SQL SELECT  *

  FROM sqlServer_Table2

;

jayanttibhe
Contributor II

Re: Concatenate

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
New Contributor III

Re: Concatenate

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
Honored Contributor III

Re: Concatenate

Did you manage to solve this problem?