help on data

[manoranjan_d]

Hi below is my data.

Gender students	Present students	Absent students
Male	9	0
Female	0	10

Now i want my table one more field as  total students count  so i want the total  present and absent put in  one field as Total students. kindly help me on the coding.please

Gender	Present	Absent	Total students
Male	9	0	9
Female	0	10	10

[#2]

Hi,

You can check another one.

[praveenak]

Hi,

Please find below script

students:

LOAD * INLINE [

    Gender students, Present students, Absent students

    Male, 9, 2

    Female, 1, 10

];

TotStudents:

LOAD

    ([Present students] + [Absent students]) as [Total students]

Resident students; 

Hope this helps you.