We’ve been busy adding new features since the last announcement.
- CASE statement is now available to support conditions in an expression. This is clearer and easier to use than the conditional operators supported till now.
- Truncate Table and Delete Table Pre-insert actions are now supported to remove all records prior to inserting new records to the destination table.
- Collect function is supported when you Aggregate records. It returns a bag of records per the grouping. This collection of records can then be manipulated further.
- New functions are supported to determine location based on IP address:
- RegionNameFromIP returns the region name
- RegionCodeFromIP returns the region code
- New functions to support processing bags (collections):
- xplenty_rb.bags_difference to return the difference between 2 bags
- xplenty_rb.concat_bag to concatenate the values in a bag to a string
- xplenty_rb.transform_bag to transform a bag of values into a bag of other values, based on an expression
Enjoy these new enhancements to analyze your data.
Thank you for using Xplenty.
