topic Re: How to add tables horizontally in QlikView

How to add tables horizontally

Thu, 21 Aug 2014 08:32:59 GMT

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

Re: How to add tables horizontally

MK_QSL — Thu, 21 Aug 2014 08:36:14 GMT

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

];

Re: How to add tables horizontally

jagan — Thu, 21 Aug 2014 08:46:23 GMT

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.

Re: How to add tables horizontally

Thu, 04 Sep 2014 09:02:31 GMT

Thanks Jagan

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

Re: How to add tables horizontally

ashfaq_haseeb — Thu, 04 Sep 2014 09:07:29 GMT

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--part-i

Regards

ASHFAQ