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-
Thank you for clarifying Jyoti. There's not a single answer that I can recommend based on your additional context. From a teamwork perspective, it may be best to split up the content into smaller w...
-
Can you share the join criteria that you're using in Datameer? Perhaps a screenshot would be helpful to verify the logic and selection of the multiple matching criteria.
-
Official comment Hi Matthew, the GROUPACCUMULATE function should be exactly what you're looking for. It's important to note that it pairs specifically with a group series function (i.e. GROUP_SORT_ASC). For example...
-
This can be done by using the FORMATDATE function to convert the DATETIME objects into a String (or multiple Strings; one for date and one for time). There is not a DATE only or TIME only object in...
-
The join criteria needs to have two criteria, not just one. Specifically, the join should be conducted on the "name" and the "month/year". Since the "month/year" is not a current column in table A,...
-
What do you expect the output to look like if a record matches both values? Is there any time where a record would match differently between the Customer Number and Customer Identifier? Also, what ...
-
The way I would do this is to add the extra columns (with empty results) into each of the sources and then use a UNION function to bring the two data sets together into a single sheet. In your exa...
-
There is an encryption script that is included with the Datameer installation which allows users to encrypt plain text into the secure password format. This is outlined in our documentation here: h...
-
With data stored in *.tsv.gz files, all columns will be read when accessing the files originally. This is forced by the storage of the actually data in a format that doesn't allow direct columnar a...
-
An alternative approach overall is this one: Add a column to your current sheet (I'll call this "Sheet1") that has a static String value of "Key". Sheet1 now has columns: Customer, Spend, "Key" A...