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-
To do this, simply duplicate the sheet results from the Join sheet and then add a new column with the multiply function like you've included here. The result will contain the 4 columns from the dup...
-
I'd recommend pivoting the data using the GROUPSELECT function first. Then you could utilize the GROUP_PREVIOUS function in a later sheet to be able to reference an ordered list of the records and ...
-
These fields are values required from Microsoft for Azure's authentication. There is more information about setting it up on their website here: https://docs.microsoft.com/en-us/azure/azure-resourc...
-
It's important to verify that there is a connection between the Datameer Cloud instance and the JIRA instance itself. Are you able to ping between the two servers? Specifically, when connected from...
-
Visual Explorer is not a feature included with the generally available demo that can be self-installed. Visual Explorer is available for demonstration through our Sales Team however. If you've init...
-
I do not recommend manually adjusting any of the files in Datameer's HDFS directory. This could lead to corruption of your Datameer instance since the data in HDFS may be inconsistent with what is ...
-
The "Connection" object would just be to a protocol where the file could be collected from (i.e. SSH). After the Connection is created, you'll be able to create an "Import Job" artifact which can c...
-
The available formatting options for number types are documented here: Formatting Columns notably the only available options are to include a thousands separator and to control the number of decima...
-
Can you share a bit more about the goal that you're trying to accomplish? There is not a direct equivalent to the HAVING clause within Datameer since it uses a different paradigm. Speaking general...
-
Hi Patrick, the syntax for Datameer is documented here: IF That seems to be the best match for this function: https://support.office.com/en-us/article/iif-function-32436ecf-c629-48a3-9900-647539c764e3