Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Hi Mathieu Drouin The following smart services have moved to the deprecated palette. It is recommended to use base product functionality where possible: Export CDT to Excel, Export SQL to Excel, Export SQL to FlatFile
What base product functionality reproduces Export CDT to Excel? With it, I was able to have a data set pre-loaded in a process variable and then transform certain columns as necessary for friendlier display - i.e. translating messy-looking dateTime columns into just a date in the customer's preferred date format, or taking bare usernames and translating those to their full name, etc... all while writing to a pre-formatted template with customized column widths and filtering applied to the column headers, as well as a cover sheet listing metrics like date generated and filters elected by the user. Is there new base product functionality that reproduces this that we haven't been told about yet?
We have a complex query that changes based on date and result need to be in excel. I used "Export SQL to Excel" for similar functionality on many applications. Now that it's deprecated I do not want to use in on my current new application. What's the replacement functionality for deprecated "Export SQL to Excel"?