Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Hi,
Check this script
Test:
LOAD * INLINE [
Test1
a
b
];
join
LOAD * INLINE [
Test3
x
y
z
];
Regards,
Jagan.
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