Dear Tresesco Biswas,
it seems to work if we only have one kind of Exam(like Math). But if we have multiple it does not work anymore:
Here is our current code:
Events:
Load
Student,
if(Exams='Math','Math' & AutoNumber(RowNo(),Student),
) as Events,
Date
resident Datatable
WHERE Exams='Math';
;
CONCATENATE
Load
Student,
if(Exams='Biology','Biology' & AutoNumber(RowNo(),Student),
) as Events,
Date
resident Datatable
WHERE Exams='Biology';
;
CONCATENATE
Load
Student,
if(Exams='Chemistry','Chemistry' & AutoNumber(RowNo(),Student),
) as Events,
Date
resident Datatable
WHERE Exams='Chemistry';
;
CONCATENATE
Load
Student,
if(Exams='Physics','Physics' & AutoNumber(RowNo(),Student),
) as Events,
Date
resident Datatable
WHERE Exams='Physics';
The problem is - if we have a student and he has only three Math courses then he has
Math1
Math2
Math3
That is correct.
But if he has 3 Math courses and 2 Biology courses he has:
Math1
Biology2
Math3
Math4
Biology5
Correct would be:
Math1
Biology1
Math2
Math3
Biology2
So we dont know exactly what to do - but one idea would be to substract the amount of Math courses for a student from the Atuonumber for Biology... something like this:
Load
Student,
if(Exams='Biology','Biology' & (AutoNumber(RowNo(),Student)-Count(Math???),
) as Events,
Date
resident Datatable
WHERE Exams='Biology';
;
Unfortunately we dont know if this is the right way and we do not know how to formulate that subquery (if this would be the right way to approach the problem).
So any help apreciated!
