Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can you please help me on this issue I am facing.
Input Table:
Pkey | Startweek | EndWeek | Value |
1 | 202203 | 202205 | 22 |
1 | 202208 | 202210 | 11 |
1 | 202215 | 202217 | 10 |
2 | 202203 | 202205 | 33 |
I want data set as like this:
Pkey | Week | Value |
1 | 202203 | 22 |
1 | 202204 | 22 |
1 | 202205 | 22 |
1 | 202208 | 11 |
1 | 202209 | 11 |
1 | 202210 | 11 |
1 | 202215 | 10 |
1 | 202216 | 10 |
1 | 202217 | 10 |
2 | 202203 | 33 |
2 | 202204 | 33 |
2 | 202205 | 33 |
Can you guys help me on this , As it is bit urgent.. I know I have posted few times back. Your help is much appreciated.
I have Calendar Table where I have Retail week as column where we have all retail week. Can we use this column to get Final table.