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

How to add tables horizontally

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

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

4 Replies
MK_QSL
MVP
MVP

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

];

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

Thanks Jagan

Can you suggest any site for innovative ways of using qlikview??

ashfaq_haseeb
Champion III
Champion III

Hi,

This is the best place.

You can even have a look at blogs mentioned here.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/22/the-qlikosphere-external-resources--pa...

Regards

ASHFAQ