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:
New functions to support processing bags (collections):
Enjoy these new enhancements to analyze your data.
Thank you for using Xplenty.