Joel Stewart

1. Community
2. Workbooks & Analytics
3. How to do group B - group A?

I intended to ensure that the following situation was not affecting the environment:  ParentWorkbook has sheets: ParentSheet1 and ParentSheet2  ParentSheet1 and ParentSheet2 are "Saved" sheets in ...

• View comment
• Joel Stewart
• March 26, 2016 00:09
• 0 votes

1. Community
2. Workbooks & Analytics
3. How to auto-update a sheet when a job finishes with the single result entry?

The documentation is available here: Exporting Data The Export Job configuration can be configured to run as soon as the workbook completes. With that configuration, the export is automatic. But it...

• View comment
• Joel Stewart
• March 28, 2016 21:24
• 0 votes

1. Community
2. Workbooks & Analytics
3. Merge Multiple Columns into one Column

I am unsure that I fully understand the expected result. However, based on the title of this post, I believe that you are interested in the COALESCE function in Datameer.  If that does not answer y...

• View comment
• Joel Stewart
• March 31, 2016 15:16
• 0 votes

1. Community
2. Workbooks & Analytics
3. Groupby count versus Flipside unique

There are many ways to do this, most simply it could be accomplished with these two functions in a new sheet: GROUPBY(1) GROUPCOUNTDISTINCT(#MyStringColumn) This will be a precise count when the wo...

• View comment
• Joel Stewart
• May 17, 2016 14:55
• Edited
• 0 votes

1. Community
2. Workbooks & Analytics
3. Workbook Column Manipulations

Hi Ross, yes that is expected. If any changes are made to the worksheet (including sorting), the sheet will revert to working with sample data instead of the full data set. If you want a quick gla...

• View comment
• Joel Stewart
• October 10, 2015 00:16
• 0 votes

1. Community
2. Workbooks & Analytics
3. Worksheet records with latest date

Peter, I'm not certain that I understand the whole scope of the workbook and the desired outcome. From my current understanding, it sounds like this is a case of Sorting Data. Specifically, analyst...

• View comment
• Joel Stewart
• May 18, 2016 22:52
• 0 votes

1. Community
2. Workbooks & Analytics
3. How do I convert <error> value to something else like 0

<error> statuses cannot be converted to another value. Can you share the details of the <error> value that you are observing so that we can help to prevent this error from occurring in the first pl...

• View comment
• Joel Stewart
• May 26, 2015 23:16
• 0 votes

1. Community
2. Workbooks & Analytics
3. analysing unstructured data

Hi Flora, thank you for the question. We offer many functions that analyze unstructured text data. Most of these are documented in our "Text Functions" section of our documentation here: https://d...

• View comment
• Joel Stewart
• June 15, 2015 23:26
• 0 votes

1. Community
2. Administration
3. Hortonworks Hadoop monitoring

I don't understand the question. Are you trying to build a use case in which you are analyzing a Hadoop cluster?

• View comment
• Joel Stewart
• November 16, 2015 20:32
• 0 votes

1. Community
2. Administration
3. lack of internal memory

Are there any errors or warnings in the conductor logs when Datameer is starting up? What is the size of the "das-data" directory within the installation directory?

• View comment
• Joel Stewart
• October 30, 2015 03:59
• 0 votes