Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Please help me to resolve the below issue:
I have a table which is comming monthly bases, but not continuouly bases. for example : we are getting data for Jan but till Aprile we are not getting any data , so for those moth we have to repeat Jan data, other senario is may be we are not getting any data till december.
in that case we have to repeat the whole data for full year.
Example:
Month | Item | Sub item | Country | Act Sale | Forecast Sale |
---|---|---|---|---|---|
1 | A | XYZ | India | 0 | 30 |
1 | B | XYZ | UK | 0 | 25 |
1 | A | PQR | USA | 0 | 10 |
1 | C | QWE | France | 0 | 40 |
1 | D | RST | UAE | 0 | 20 |
Month | item | Sub Item | Country | Act Sale | Forcast Sale |
---|---|---|---|---|---|
1 | A | XYZ | India | 30 | 0 |
2 | B | XYZ | UK | 10 | 0 |
3 | C | QWE | France | 25 | 0 |
4 | D | RST | UAE | 20 | 0 |
5 | A | PQR | USA | 30 | 0 |
6 | B | XYZ | UK | 45 | 0 |
7 | C | PQR | USA | 40 | 0 |
8 | D | QWE | France | 15 | 0 |
9 | A | RST | UAE | 25 | 0 |
In the Final result I want to repeat the first table data till 9th month
Output Reult:
Month | Item | Sub item | Country | Act Sale | Forecast Sale |
---|---|---|---|---|---|
1 | A | XYZ | india | 30 | 30 |
1 | B | XYZ | UK | 25 | |
1 | A | PQR | USA | 10 | |
1 | C | QWE | France | 40 | |
1 | D | RST | UAE | 20 | |
2 | A | XYZ | India | 30 | |
2 | B | XYZ | UK | 10 | 25 |
2 | A | PQR | USA | 10 | |
2 | C | QWE | France | 40 | |
2 | D | RST | UAE | 20 |
Like the above output our value will repeat till September.
Please help me to generate the data for moth which is not availble in table.
Thanks & Regards,
Nisha
Hi,
Please have a look the creen shot, even when the column is added that time it self it's not generating the missing month
I not getting.. can you upload the qvw?
Hi Nisha,
Add if null peek expression for other columns as we added for data column.
if(.. Peek()... ) as col1, if(.. Peek().. ) as col2.
Thanks,.
Is it working now..??
Hi Prashanth,
No , it's not working, i tried the below code which is suggested by Manish and done some changes,
it's working now.