Information
Method of study ( needs to be calculated) Type ( data form system)
Taught course part time FEEDER or INTENSIVE or BESPOKETAU or BESPOKEIN
Revision WEREV or QBREV or STDREV
Taught course and revision (FEEDER or BESPOKETAU) and (WEREV or QBREV or STDREV)
Distance learning and revision (BASIC or BASICOL or BASICPLUS) and (WEREV or QBREV or STDREV)
data form system
Cust Type Paper
1 FEEDER P1
1 WEREV P1
1 BESPOKEIN P2
2 BASIC P3
2 STDREV P3
3 FEEDER P1
3 BESPOKEIN P3
output required
cust method of study P1 P2 P3 ( hence the papers)
1 Taught course and revision 1 0 0
1 Taught course part time 0 1 0
2 Distance learning and revisio 0 0 1
3 Taught course part time 1 0 1
grouping will be required on cust and Method of study,
CR var 8.5 DB Oracle
if any one can suggest how i can approach this, since i am struggling to do this grouping since it need to be calculated for multiple situations
any help will be much appreciated
thanks
Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:
Add a comment