Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Tags (3)
14 Replies

Re: union all

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

Re: union all

You may check with rules for UNION ALL statement at

SQL Union - w3resource

amit_saini
Honored Contributor III

Re: union all

Sub,

Please see the attachment.

Thanks,

AS

Not applicable

Re: union all

Unable to open the file. I hope access problem.

Re: union all

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

Re: union all

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

Re: union all

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

Highlighted
jsaradhi
Valued Contributor

Re: union all

Not applicable

Re: union all

Thank you all.

I have an idea now.

@Sub2a

Community Browser