Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
salto
Specialist II
Specialist II

Combine two lists

Hello,

I have two tables (Items and Countries) with one single column on each table:

ItemID
Item_1
Item_2
Item_3

Countries

CountryID
Germany
UK
USA

I need to merge both tables in one resultant table that has all the possible combinations of both tables:

ItemIDCountryID
Item_1Germany
Item_2Germany
Item_3Germany
Item_1UK
Item_2UK
Item_3UK
Item_1USA
Item_2USA
Item_3USA

How can this be achieved? Thanks in advance.

1 Solution

Accepted Solutions
bumin
Partner - Creator II
Partner - Creator II

concat the next table to the first one with outer join

View solution in original post

2 Replies
bumin
Partner - Creator II
Partner - Creator II

concat the next table to the first one with outer join

salto
Specialist II
Specialist II
Author

Many thanks!