Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
]
You may check with rules for UNION ALL statement at
Sub,
Please see the attachment.
Thanks,
AS
Unable to open the file. I hope access problem.
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
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
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
and this thread http://community.qlik.com/message/461339#461339
Thank you all.
I have an idea now.
@Sub2a