Hi Vinu, OK. I suggest that you help us reproduce this some more then... Maybe you can take a look at the commit I did to (in)validate the issue. Maybe you can tell me/us what is missing from those unittests to reproduce. Maybe your file does not contain a null but something else?
Kasper 2014-08-11 11:04 GMT+02:00 Vinu Agnihotri <[email protected]>: > Hi Kasper > > Many Thanks, > > This was just a detailed email explanation to help you understand if I > have not explained clearly. > > I have asked the team to subscribe me, mean while can you please if > possible just reply and let me know what have you replied > > Thanks > Vinu > > > On Mon, Aug 11, 2014 at 3:01 PM, Kasper Sørensen < > [email protected]> wrote: > >> Hi Vinu, >> >> We did see your first message on this topic, and also replied to it. But >> I think you're still not subscribed to the mailing list to get the >> responses ... Send a mail to [email protected] >> to get subscribed. >> >> Best regards, >> Kasper >> >> >> 2014-08-11 5:32 GMT+02:00 Vinu Agnihotri <[email protected]>: >> >> Hi Kasper, >>> >>> I am from Singapore and have recently started using the META Model. >>> >>> My Database is a CSV file. >>> >>> I am using the aggregate SUM function in a simple Aggregate Function >>> using >>> a group by query. >>> >>> Select...... (FUNCTION.SUM, (Column_Name) >>> >>> In this case there is a time where the values in the row is blank or null >>> for the column for which I am doing the SUM Aggregation >>> >>> When this is the case I am getting an error "Could not convert to >>> number: " >>> " >>> >>> What I intend to do is either make the value 0 when it is Null or not >>> include these null values while doing the aggregation. >>> >>> NO Name Amount >>> 1 Origin 50 >>> 2 House >>> 3 Origin 30 >>> 4 House 40 >>> >>> In the above example when I do a SUM on Amount group by Name, I expect to >>> have two rows as a output with origin as 80 and House as 40 as their >>> Amounts , but since for no 2 the amount is null, My code does not >>> complies >>> and I get the error. >>> >>> >>> My apologies for asking such an easy question >>> >>> Thanks >>> Vinayak >>> >> >> >
