Elwyn Roberts
- Total activity 35
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 5
- Subscriptions 5
Activity overview
Latest activity by Elwyn Roberts-
Elwyn Roberts commented,
Very detailed explanation - thanks. As mentioned, I am using your first solution (formatting to drop the milliseconds) which solves the issue. Thanks to both of you for the follow up and the solu...
-
Elwyn Roberts commented,
Here you are. I also included the fix mentioned from Konsta and I did the TIMESTAMP for this as well, just for reference - I guess to show what values are going into TIMESTAMPDIFF that works and w...
-
Elwyn Roberts commented,
Currently using Version 11.1.12A ticket wont be necessary as what you suggested did work. But I am confused as to why. The field #Start and #End were already DATE type fields so I used FORMATDATE...
-
Elwyn Roberts created a post,
DataMeer TIMESTAMPDIFF Rounding issue?
To calculate the number of seconds between two dates, I am using the TIMESTAMPDIFF function (only if there is a start datetime).IF(ISBLANK(#Start), 0, TIMESTAMPDIFF("SECOND", #Start, #End))For some...
-
Elwyn Roberts commented,
OK so I have diagnosed it further and determined it is not a Datameer issue, but an issue with the file being created. The file is being generated automatically from a system called Aspect. The f...
-
Elwyn Roberts commented,
Hi Alan - we have done what you suggested, it runs on a schedule at 11.30 so will see if it is successful.Konsta - we have Excel 2013, although the file is generated from a Aspect system I believe ...
-
Elwyn Roberts commented,
It is in the Data Details and does have include. As mentioned, if we put space in the first row after the heading, it imports fine. (there are roughly 200K rows, the first row with values is at r...
-
Elwyn Roberts commented,
Thanks Alan. Unfortunately it looks like we are not using the same version... I dont have that option available.
-
Elwyn Roberts created a post,
Importing Excel Issue if some rows have null
We have an excel file that we import. One particular column sometimes does not have any values in it (so its null). If the first x number of rows being imported are null, then the import "skips" ...
-
Elwyn Roberts commented,
Ok solved it. It was as suspected a line feed (carriage return)...although I thought the // in the regex was supposed to handle that. When I was testing, I would copy the text into a new workbook...