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-
Official comment To do this with the native functions in Datameer, this would require a separate sheet for each grouping and then union the resulting groups together. It'd also be possible to create a custom funct...
-
This exception commonly occurs when results from a Workbook are configured to be partitioned by a date column and there is one or more rows where the partitioned column is blank or has a null value...
-
Datameer's current functionality is compatible with date partitions only as outlined in detail in the documentation: Partitioning Data in Datameer General string partitions such as "region" are not...
-
Brian, you're correct that the Join approach takes the full records into account. One method to a element-by-element match is to use the INTERSECT and REMOVEALL functions to take the intersection a...
-
The workbook will reference the data source that is is directed to access. If you setup an Import Job for example that uses "Replace" this can ensure that you get only the records that were importe...
-
In the Advanced Filter section, you'll want to use a double "=" character for an "equals" comparison. This is described in more detail in the documentation here: https://www.datameer.com/documentat...
-
Here's how I would start for the first couple of cases: CASE(T(#ColumnName); ISNULL(#ColumnName); null; <boolean condition 2>; <return value 2>; ...) It's hard to extrapolate the other SQL for...
-
Aditya, you'll want to include the "else" case first as part of the default value per the documented syntax: CASE(<default value>; <any>; <case 1>; <return value 1>; <case 2>; <return value 2>; ......
-
Yes, simply re-open the Join dialog when on the Join sheet to review or edit the logic for the Join itself.
-
Srikanth, that's not a capability of that function. Can you share an example though? Perhaps there is an alternative method that could be used for your instance.