topic Re: Join(Table1) in Script in QlikView

Join(Table1) in Script

Thu, 06 Nov 2014 02:35:12 GMT

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 — Thu, 06 Nov 2014 02:43:14 GMT

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

afurtado — Thu, 06 Nov 2014 02:45:22 GMT

Hi.

Maybe these docs can help you.

Best,

Alessandro Furtado

ashfaq_haseeb — Thu, 06 Nov 2014 06:22:47 GMT

Hi,

Check this

Regards

ASHFAQ