Alan
- Total activity 390
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 46
- Subscriptions 167
Comments
Recent activity by Alan-
Hi Fenghua, You can find all our supported SQL functionality here: Using SQL Sheets: SQL Editor Features The error message is correct. The SQL editor does n't support the CUBE, ROLLUP, or GROUPSET...
-
Hi Mario, Our AVERAGE function provides the average of each row for the columns specified as arguments. For example, if you have three columns and AVERAGE them as follows: AVERAGE(Column1;Column2;C...
-
Hi Elwyn, Thank you for supplying this collateral. We'll perform some testing an let you know what the outcome is. Alan
-
Hi Elwyn, Datameer DATE fields store data as Epoch time, the number of milliseconds since UNIX Epoch. I suspect we may be encountering some incorrect rounding based on the internal representation....
-
Hi Dave, Thanks for reaching out. Unfortunately Datameer X does not support in line comments within the formula builder. However, each column does have a Description text area within the Inspecto...
-
On the Configure step, could you try raising the number of sample records to 10,000 to see if increasing the sample will help catch a column with data? If this doesn't work, I'll need to do some te...
-
Hi Elwyn, Does the column appear in the Define Fields step? Or is it missing entirely? You might just need to click the 'include' checkbox on the column there. Alan
-
Hi Elwyn, You can work around this within the product by expanding the Advanced section of the Data Details step while creating the Import job. There, you can increase the number of records read f...
-
Hi Ganesh, Please refer to the documentation on our TIMESTAMPDIFF function. It takes arguments for start date, end date, and date interval. You can specify Months as the interval, and then specify...
-
Hi Ganesh, The most likely explanation here is that the data for your grouping columns has changed. If you need further assistance with this, please open a ticket up with the support team and inc...