Forum Discussion
Solved
Join static pattern table to dynamic table
Hello, I have one table that contains 13 (static countries) rows for each week. I need to report all those rows every week, however, sometimes happen that I don't have data for some country, however...
Hi vojtechsima ,
Please create 3 tables.
1. 13 countries
2. week:
table 2 = GENERATESERIES ( 1, 52 )3. crossjoin table:
Table 3 = CROSSJOIN('Table','table 2')Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi vojtechsima ,
Please create 3 tables.
1. 13 countries
2. week:
table 2 = GENERATESERIES ( 1, 52 )3. crossjoin table:
Table 3 = CROSSJOIN('Table','table 2')
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
