Error while using min,max ,count aggregations

[jyothish8807]

LOAD

[Si no], [Email ID], Name, English, Hindi, Maths, Science,max(Science) as Sciencemax

FROM

(ooxml, embedded labels, table is Sheet1);

Iam not able to display the results of " min(Science) " command. its displaying error....

HELP

[sreenivas · Accepted solution]

for this u need to use Group By Clause after the

LOAD

[Si no], [Email ID], Name, English, Hindi, Maths, Science,max(Science) as Sciencemax

FROM

(ooxml, embedded labels, table is Sheet1)

Group By

[Si no], [Email ID], Name, English, Hindi, Maths;

[#3]

hi,

to use aggregate functions like min, max count, we have to use group by cluase.

so

first u load:

Student:

LOAD

[Si no], [Email ID], Name, English, Hindi, Maths, Science

FROM

(ooxml, embedded labels, table is Sheet1);

Then load

load [Si no],

         max(Science) As Sciencemax

resident Student

group by [Si no];

hope it helps you.

Niranjan M.

[#4]

hi,

use according to this example,

Load Month, min(Sales) as SmallestSalePerMonth from abc.csv group by Month;

Load Month, min(Sales, 2) as SecondSmallestSalePerMonth from abc.csv group by Month;

hope it help you.

[jyothish8807]

Is it compulary to use a group by statement? Is there any alternative way without using group by...