Maybe you can create the JIRA issue for it :-) That would help me a little, then I'll get the patch through and we'll see if we can make a bugfix release soon.
2014-08-13 6:55 GMT+02:00 Vinu Agnihotri <[email protected]>: > Hi Kasper, > > Thank you for the email, yes this is exactly what I was trying to do. > I am using the Excel file as an input from a third party and thus at times > the value in the column is Blank. > I had tried to explain the same in the example which was given by me. > > What I meant to ask is even if the value is empty blank cant we assume it > to be 0 or null and skip it in the aggregation? > Or any other utility by which we can have a null check? > > Thanks for raising review request. > Let me know if there is anything else by which I can help you. > > Many thanks > > Vinayak > > > On Wed, Aug 13, 2014 at 2:26 AM, Kasper Sørensen < > [email protected]> wrote: > >> Hi Vinu, >> >> Although I am hoping you will still get back to us with more info - I was >> trying to think a bit about this on my own too. And I think the case you're >> running into isn't that you have a NULL value, but that you have a >> blank/empty string! In that case I just confirmed that an exception will be >> thrown. I think it's fair for us to add it as a feature that empty strings >> are treated like nulls here. >> >> Best regards, >> Kasper >> >> >> 2014-08-11 12:14 GMT+02:00 Kasper Sørensen < >> [email protected]>: >> >> 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 >>>>>> >>>>> >>>>> >>>> >>> >> >
