Discussion Board for collaboration related to QlikView App Development.
in a Qlikview script I would like to create a table resulting of a cartesian product.
The first table contains Products :
The second table contains Countries :
Il would like a table as :
product_id, product_name, country_id, country_name
1 AAAA FR France
1 AAAA ES Spain
2 BBBB FR France
2 BBBB ES Spain
I tried using "outer join" but the result is :
1 AAAA - -
2 BBBB - -
- - FR France
- - ES Spain
Can someone help me to have the expected result ?
Thanks in advance
you should use left join or right join
View solution in original post
load * inline [ product_id, product_name 1,AAAA 2,BBBB ]; join load * inline [ country_id, country_name FR,France ES,Spain ];
Thanks for your answer. It works.
In fact my problem was with the product table load and not with the join.