Join(Table1) in Script

[#1]

Hi All,

I am unable to undertsand JOIN mentioned in Qlikview help point I.

Please help to explain with the two tables shown in point II.

Thanks in advance.

I)
tab1:

LOAD * FROM file1.csv;

tab2:

LOAD * FROM file2.csv;

.. .. ..

join (tab1) LOAD * FROM file3.csv;

II)
Table1:
Load * inline
[
A,B
1,aa
2,bb
3,cc
4,dd
]
;

Join(Table1)

Table2:
Load * inline
[
A,C
1,xx
2,yy
5,tt
]
;

[danieloberbilli]

Also have a look at these threads regarding Joins - how to / why / when to use:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join

http://community.qlik.com/groups/qvscriptor-from-schema-to-script/blog/2011/11/11/understanding-join...

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/14/merging-data

[afurtado]

Hi.

Maybe these docs can help you.

Best,

Alessandro Furtado

[ashfaq_haseeb]

Hi,

Check this

http://community.qlik.com/docs/DOC-6562

http://community.qlik.com/thread/39177

http://community.qlik.com/thread/134760

Regards

ASHFAQ