Generate data for those month which is not in table

[nisha_rai]

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

[nisha_rai]

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

[MK_QSL]

I not getting.. can you upload the qvw?

[d_prashanthredd]

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,.

[d_prashanthredd]

Is it working now..??

[nisha_rai]

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.