Alan
- Total activity 389
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 46
- Subscriptions 166
Comments
Recent activity by Alan-
Hi Tugrul, Create a copy of your worksheet. Then, add two columns to the left side of the new sheet. In the first column put GROUPBY(1) in the formula bar, then in the second column put GROUPROWNU...
-
Hi Steven, Unfortunately Importing data is a relatively simple process that doesn't allow for regular expressions or even complex SQL - just basic SELECT statements. You'll only be able to achieve ...
-
Hi Steven, 1. You can definitely move the negative symbol in a few ways. You would import it as a string value. You could use a Regex to remove the trailing -, and add a leading - in the same ste...
-
Hi Joshua, 0 0 1 */3 * "At 00:00 on the first day of the month, in every 3rd month." Alan
-
Hi Joshua, The custom SQL interface only supports selecting data, not updating or deleting data. You'll note that the text explanation next to the custom SQL box mentions to enter your select stat...
-
Hi Kamal, Create a new column where you divide the source column by 1000, and apply the ROUND function. Create a second new column where you multiply the first new column by 1000. Sincerely, Alan
-
Hi Jayraj, IF((SUBSTR(#SHEET1!XXXX;14;1) = 'L'); 'DSA'; IF((SUBSTR(#SHEET1!XXXX;14;1) = 'l'); 'DSA'; 'TAR')) IF substring = L THEN DSA ELSE IF substring = l THEN DSA ELSE TAR Let me know if you hav...
-
Hi Baz, Yes all dates are calculated from epoch time, in milliseconds and then displayed according to their parse pattern. If the data only includes a timestamp, and not the full date, you'll need ...
-
Hi Baz, You'll want to use the ASDATE function to convert from string to date type. You'll need to use a Parse Pattern to convert your string. Here's the full Datameer Functions reference page, so...
-
Hi Aditya, You're looking for Data Driven triggering. Please see our documentation here: Configuring Workbook Settings - Advanced Scheduling, Data Driven Options Alan