Join ?

[#1]

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.

K

[Anonymous · Accepted solution]

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.

[jagan]

Hi,

Check this script

Test:

LOAD * INLINE [

Test1

a

b

];

join

LOAD * INLINE [

Test3

x

y

z

];

Regards,

Jagan.

[jagannalla]

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