Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Merge data

Hi,

I have 3 resident tables:

MARKETS

     Market_ID

     Market_Name

PRODUCTS

     Product_ID

     Product_Name

PERIODS

     Period_ID

     Period

I need to create a temparary table that would have records for each Market_ID, Product_ID, Period_ID. The output should looks like this...

Market_IDProduct_IDPeriod_ID
A111116
A111117
A111118
A122226
A122227
A122228
A133336
A133337
A133338
A211116
A211117
A211118
A222226
A222227
A222228
A233336
A233337
A233338

Is there an easy way to create this table without having to use 'for' loops? it is just too slow. I am wotking with about 500 Markets, 50000 Products and 36 Periods.

Any help would be appreciated.

1 Solution

Accepted Solutions
jvitantonio
Valued Contributor III

Re: Merge data

Make a Cross Join

1 Reply
jvitantonio
Valued Contributor III

Re: Merge data

Make a Cross Join

Community Browser