Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

union all

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

14 Replies
Gysbert_Wassenaar

Qlikview doesn't know the union keyword. The qlikview equivalent is concatenate. It will force adding data from a load to an already existing table

Test:

LOAD * Inline

[

A,B

1,2

2,3

3,4

];

CONCATENATE(Test)

Load * Inline

[

C,D

6,7

5,6

4,5

]


talk is cheap, supply exceeds demand
nagaiank
Specialist III
Specialist III

You may check with rules for UNION ALL statement at

SQL Union - w3resource

amit_saini
Master III
Master III

Sub,

Please see the attachment.

Thanks,

AS

Not applicable
Author

Unable to open the file. I hope access problem.

ashfaq_haseeb
Champion III
Champion III

Hi,

Tun below code in your script

Table:

LOAD * Inline

[

A,B

1,2

2,3

3,4

];

CONCATENATE

Load * Inline

[

C,D

6,7

5,6

4,5

]

Regards

ASHFAQ

Not applicable
Author

Still confusion with that.

Pls give me some clarity on this.

a. Column names are not same, is it working. Because in Qlikview column names are same then it will be concatenate. Here column names are not same...so is it possible Concatenate....pls provide the final output.

b. as well as NoConcatenate ...

C. if i forgot to put Conctaenate/NoConcatenate keyword then what is the result.....

Thanks in advance,

@Sub2a

ashfaq_haseeb
Champion III
Champion III

Sub2a Red2y wrote:

a. Column names are not same, is it working. Because in Qlikview column names are same then it will be concatenate. Here column names are not same...so is it possible Concatenate....pls provide the final output.

Hi,

If field names are same then no need to write concatenate it will be auto concatenated.

If not then we will force concatenate result by writing concatenate key word.

For rest I would suggest you to go through the below link.

http://community.qlik.com/docs/DOC-6562

Regards

ASHFAQ

Anonymous
Not applicable
Author

Not applicable
Author

Thank you all.

I have an idea now.

@Sub2a