Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the book Qlikview 11 for Developers, an example of a "concatenation" as in the following script is given:
Table1:
LOAD * INLINE
[
A, B, C
1, 1, 1
2, 2, 2
3, 3, 3
];
CONCATENATE (Table1)
LOAD * INLINE
[
B, C, D
2, 2, 2
3, 3, 3
5, 5, 5
];
with the following result as given in the book:
Table1
A B C D
1 1 1
2 2 2
3 3 3
2 2 2
3 3 3
5 5 5
But when I run the code, I get a "merging" of the table values as follows:
A B C D
1 1 1 2
2 2 2 3
3 3 3 5
5 5
Based on the example in the book, a "concatenation" should not be merging [if I have that verb correct] the common table values but should instead display all duplicated values as entered. Is the book sample wrong or am I missing something?
Thanks
Dave
I just copied that code into a qvw and got the exact result in the book. Maybe try the script again?
Look at this: