How to add tables horizontally

[#1]

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

[MK_QSL]

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 · Accepted solution]

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.

[#4]

Thanks Jagan

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

[ashfaq_haseeb]

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