Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have a straight table as :
Product_Code | CalendarMonth | StandardCost | Q |
5002041 | Jan | 194567.77 | 93 |
Feb | 0 | 108 | |
Mar | 0 | 114 | |
Apr | 0 | 92 | |
May | 0 | 52 | |
Jun | 0 | 56 | |
Jul | 0 | 92 | |
Aug | 0 | 107 | |
Sep | 96240.15 | 69 | |
Oct | 0 | 147 | |
Nov | 0 | 90 | |
Dec | 0 | 136 |
I want the output as :
Product_Code | CalendarMonth | StandardCost | Q |
5002041 | Jan | 194567.77 | 93 |
Feb | 194567.77 | 108 | |
Mar | 194567.77 | 114 | |
Apr | 194567.77 | 92 | |
May | 194567.77 | 52 | |
Jun | 194567.77 | 56 | |
Jul | 194567.77 | 92 | |
Aug | 194567.77 | 107 | |
Sep | 96240.15 | 69 | |
Oct | 96240.15 | 147 | |
Nov | 96240.15 | 90 | |
Dec | 96240.15 | 136 |
Manish
I would look at sorting that in the load script, probably using the Previous() and maybe Order By, depending on your raw input data.
Best Regards, Bill
As far as Raw data is concerned , i have 2 tables ..
First Table looks like :
ProductCode | Month Year | StandardCost |
5002041 | Jan-13 | 194567.77 |
5002041 | Sep-13 | 96240.15 |
and Second
ProductCode | Month Year | Qauntity |
5002041 | Jan-13 | 93 |
5002041 | Feb-13 | 108 |
5002041 | Mar-13 | 114 |
5002041 | Apr-13 | 92 |
5002041 | May-13 | 52 |
5002041 | Jun-13 | 56 |
5002041 | Jul-13 | 92 |
5002041 | Aug-13 | 107 |
5002041 | Sep-13 | 69 |
5002041 | Oct-13 | 147 |
5002041 | Nov-13 | 90 |
5002041 | Dec-13 | 136 |
Manish
Is the attached qvw the sort of thing you were after ?
Best Regards, Bill