Discussion Board for collaboration on QlikView Scripting.
I have 3 resident tables:
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...
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.
Go to Solution.
Make a Cross Join