Joel Stewart
- Total activity 778
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 4
- Subscriptions 347
Comments
Recent activity by Joel Stewart-
I'd recommend reviewing the logs/conductor.log file for any clues about the error message. This could contain more information about why the REST API call is being returned as a failure.
-
I recommend doing any date-type comparisons as DATE objects rather than STRING objects. Strings require that the format of the date is in descending order of magnitude for calendar values (year, mo...
-
Official comment This could be accomplished using the following steps: 1. In each of your Worksheets, add a column that identifies the worksheet name (i.e. SheetName = "WorksheetA") 2. For each of your Worksheets, ...
-
This sounds like a permissions limitation. The default permissions for the Analyst role exclude "File Browser -> Infographics -> make public" or "Allows to publish infographics (read access to ever...
-
Thanks for the clarification. Here's one approach that would work: Create a sheet to calculate the maximum date (date2) GROUPBY(1) GROUPMAX(#DataSheet!date2) Create a Join Sheet to inner-join #Da...
-
John, the GROUPBY(#FirstColumn) would only output a single value. So for this example data, you'd get the following results: e.g. abc, xyz, 123, 567 abc, xyz, 123, 567 abc, xyz, 123, 568 GROUPBY(#...
-
Official comment To combine duplicated rows, you may use a grouping function. In the example above, a GROUPBY(#FirstColumn) would result in only three rows. The other values could be copied over from the original...
-
I'd recommend reviewing the GROUPPERCENTILE function. With this function, one can identify the percentile grouping at an arbitrary level. If needed, later in the workbook, one could add a filter t...
-
In that case, the data can be extracted using the https://documentation.datameer.com/documentation/display/DAS70/REMOVE_HTML_TAGS function directly. This is the same process that I recommended duri...
-
This is easiest to handle when the data is being brought into Datameer using the HTML Files type: https://documentation.datameer.com/documentation/display/DAS70/Importing+HTML+Files Specifically, i...