topic Re: Join ? in QlikView

Join ?

Mon, 26 Nov 2012 09:34:05 GMT

Hi all,

i have two tables:

Table A:

Name	Country
John	Finland
Mike	Italy

Table B:

Country
Finland
Italy
Sweden

What i want is to JOIN the two tables and have one record for every compination of Name and Country:

Result:

Name	Country
John	Finland
John	Italy
John	Sweden
Mike	Finland
Mike	Italy
Mike	Sweden

Thanks a lot for some advise.

Re: Join ?

Anonymous — Mon, 26 Nov 2012 09:40:50 GMT

If you just load Name in Table A (and not Country), and then join Country in Table B and join, QlikView will create a cartesian product, i.e. every combination of the two tables so you'll get all country values for each Name.

Re: Join ?

jagan — Mon, 26 Nov 2012 09:43:09 GMT

Hi,

Check this script

Test:

LOAD * INLINE [

Test1

];

join

LOAD * INLINE [

Test3

];

Regards,

Jagan.

Re: Join ?

jagannalla — Mon, 26 Nov 2012 09:50:35 GMT

Hello,

Try this:

TableA:
Load Name from TableA;
Join
Load Country from TableB:
See the result in tablebox with fields Name and Country

Hope it helps you

Cheers!!

Jagan