Script for this output

[shiveshsingh]

I am attaching problem pic and expected result pic.

please let me know how it is possible to get result pic.

problem pic:-

[sunny_talwar]

May be this

LOAD *,

  Month(MonthStart(Date, Jump*(IterNo()-1))) as Month

While IterNo() <= Freq;

LOAD *,

  12/Freq as Jump;

LOAD * INLINE [

    Account No, Freq, Date

    10001, 12, 03-04-2015

    10002, 1, 05-06-2015

    10003, 4, 03-02-2015

    10004, 4, 05-07-2015

    10005, 2, 04-04-2015

    10006, 2, 07-07-2015

];

[shiveshsingh]

hi

plz share expression, license fr qliview is over

[sunny_talwar]

Expression

=Count([Account No])

[shiveshsingh]

how can we expand month to column, like jan, feb, march should be a newcolumn..

when i m loading, those are coming in one column i.e. month

[sunny_talwar]

Not sure what you mean? May be you need The Generic Load