For the Enterprise version (.msi installer) the Community Feed (Gallery) is not added by default like for the Community Edition (.exe installer). You can add it manually: right click on the left side in Package Manager - Configure Sources and add the feed in @balupad14’s screenshot there.
I have a datatable with 29 columns. I’d like to get Max(datetime) on 1 column, grouped by 7 columns, but also include the rest of the columns in the resulting table. Using the activity I only got 8 columns returned (the 7 grouped by + the 1 aggregated max)
Do you have any ideas on how to achieve this? Thanks!
I’m having some problems using the aggregation (Max) of your DataTableExtensions activity. I have a datatable and am trying to group 9 columns by the max datetime in a 10th column.
It works great except when the datatable has 2+ rows where the group of 9 columns match. However, if it only has one row, then it returns a blank/null value instead of the datetime of that 1 row. Do you have any idea why this is happening?
It’s coming from an Oracle database. Behavior changes when saving it to excel/csv and then reading to datatable as it changes the datatypes. We are’t able to save the files as CSV/Excel either, only read from the database per requirements from the customer. So i’m not sure it’d be helpful, plus I’d have to scrub a lot of the data to remove sensitive information.