generate in script 12 monthly values from a single year value

[omyahamburg]

Dear All

I have a table with a lots of Years and a values.

Eg.

Year     value

2012     1200

...

I would like to generate within my script a table which

splits these values into the months:

Eg:

YearMonth     value

2012-01	100
2012-02	100
2012-03	100
2012-04	100
2012-05	100
2012-06	100
2012-07	100
2012-08	100
2012-09	100
2012-10	100
2012-11	100
2012-12	100

Can anyone tell me how to generate this ?

I hope an easy task for the experts, but I am still beginner

and appreciate your help.

Cheers

Joerg

[omyahamburg]

Dear Jagan

Also a nice solution for me.

Thanks a lot.

Joerg

[Priyanka_Mani]

Hi,

Could you please share the code here. Is that using IterNo() function?

Thanks!