union all

[#1]

Test:

LOAD * Inline

[

A,B

1,2

2,3

3,4

];

union all

Load * Inline

[

C,D

6,7

5,6

4,5

]

where i did the mistake, can any one help....

Error:-

Unknown statement

union all

[ashfaq_haseeb]

Hi,

Can you close this thread by selecting appropriate answer.

Regards

ASHFAQ

[jagan]

Hi,

Test:

LOAD * Inline

[

A,B

1,2

2,3

3,4

];

Concatenate(Test) 

Load * Inline

[

C,D

6,7

5,6

4,5

];

Which is similar to

SELECT * from Table1

UNION ALL

SELECT * from Table2;

Regards,

Jagan.

[Anonymous]

Hi,

Are you doing union all on inline table or data from DB?

because if you are doing on data from different tables in DB  Union all works.

But not on inline tables ,as qlikview doesn't recognize the Union all keyword..

see below link:

http://community.qlik.com/message/592215#592215

[#5]

Hi Nitha,

** Inline its not working. After that i did like this...

I Create two tables in Sql Server.

Create Table Test1

(

  Col1 char(1),

  Col2 int

)

Create Table Test2

(

  Col1 char(1),

  Col2 int

)

Insert into Test1 values('A',1),('B',4),('C',3)

Insert into Test1 values('G',9),('y',4),('R',6)

The above two tables are accessed in QlikView, i'm getting now.

<Data Base Connection>

select Col1,Col2 from Test1

unionall

select Col1,COl2 from Test2;

Thank you so much Nitha. You are r8, Awesome.

Thank you all.

@Sub2u

[Anonymous]

Good Welcome