Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends
I have two data sets like this
x y z
1 2 3
4 5 6
7 8 9
a b c
1 2 3
4 5 6
7 8 9
I want to add them horizantally like this
x y z a b c
1 2 3 1 2 3
4 5 6 4 5 6
7 8 9 7 8 9
Thanks
Pavan
Hi Pavan,
Try like this
Data:
LOAD
RowNo() AS Key,
*
FROM Table1;
Left Join(Data)
LOAD
RowNo() AS Key,
*
FROM Table2;
Join is not mandatory, with join also the tables join logically by using Key column,
Regards,
Jagan.
Load *, RowNo() as ID Inline
[
x, y, z
1, 2, 3
4, 5, 6
7, 8, 9
];
JOIN
Load *, RowNo() as ID Inline
[
a, b, c
1, 2, 3
4, 5, 6
7, 8, 9
];
Hi Pavan,
Try like this
Data:
LOAD
RowNo() AS Key,
*
FROM Table1;
Left Join(Data)
LOAD
RowNo() AS Key,
*
FROM Table2;
Join is not mandatory, with join also the tables join logically by using Key column,
Regards,
Jagan.
Thanks Jagan
Can you suggest any site for innovative ways of using qlikview??
Hi,
This is the best place.
You can even have a look at blogs mentioned here.
Regards
ASHFAQ