Contents:
March 22, 2021
Release 8.2
What's New
Preferences:
- Re-organized user account, preferences, and storage settings to streamline the setup process. See Preferences Page.
Spark Execution Properties Settings:
Advanced Spark parameters have been newly added to the Spark running environment. Use these parameters to override the global Spark settings for individual jobs. For more information, see Spark Execution Properties Settings.
Improve Accessibility of Job Results:
The Jobs tabs have been enhanced to display the list of latest and the previous jobs that have been executed for the selected output.
For more information, see View for Outputs.
Sample Jobs Page:
Changes in System Behavior
None.
Key Fixes
| Ticket | Description |
|---|---|
| TD-59236 | Use of percent sign (%) in file names causes Transformer page to crash during preview. |
| TD-59218 | BOM characters at the beginning of a file causing multiple headers to appear in Transformer Page. |
| TD-58932 | Cannot read file paths with colons from EMR Spark jobs |
| TD-58802 | Running job on Photon using zipped CSV that was uploaded yields garbage characters in output. |
| TD-58694 | Very large number of files generated during Spark job execution |
New Known Issues
| Ticket | Description |
|---|---|
| TD-60701 | Most non-ASCII characters incorrectly represented in visual profile downloaded in PDF format. |
March 9, 2021
Release 8.1, push 2
What's New
Macro updates:
You can replace an existing macro definition with a macro that you have exported to your local desktop.
NOTE: Before you replace the existing macro, you must export a macro to your local desktop. For more information, see Export Macro.
For more information, see Macros Page.
Changes in System Behavior
None.
Key Fixes
None.
New Known Issues
None.
February 26, 2021
Release 8.1
What's New
Specify column headers during import
You can specify the column headers for your dataset during import. For more information, see Import Data Page.
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-56170 | The Test Connection button for some relational connection types does not perform a test authentication of user credentials. |
| TD-54440 | Header sizes at intermediate nodes for JDBC queries cannot be larger than 16K. Previously, the column names for JDBC data sources were passed as part of a header in a GET request. For very wide datasets, these GET requests often exceeded 16K in size, which represented a security risk. |
New Known Issues
None.
January 26, 2021
Release 8.0
What's New
Import:
- Improved method for conversion and ingestion of XLS/XSLX files. For more information, see Import Excel Data.
Recipe development:
- The Flag for Review feature enables you to set review checkpoints in your recipes. You can flag recipe steps for review by other collaborators for review and approval. For more information, see Flag for Review.
Update Macros:
- Replace / overwrite an existing macro's steps and inputs with a newly created macro.
- Map new macro parameters to the existing parameters before replacing.
- Edit macro input names and default values as needed.
- For more information, see Create or Replace Macro.
- For more information, see Overview of Macros.
- For more information, see Create or Replace Macro.
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
December 21, 2020
Release 7.10
What's New
Tip: Check out the new in-app tours, which walk you through the steps of wrangling your datasets into clean, actionable data.
Import:
- The maximum permitted size of a file uploaded through Trifacta application has been increased from 100 MB to 1 GB.
Photon:
Introducing Trifacta Photon, an in-memory running environment for running jobs. Embedded in the Trifacta Wrangler, Trifacta Photon is fast and best-suited for small- to medium-sized jobs.
- When you choose to run a job, you can now choose to run a job on Trifacta Photon.
- Trifacta Wrangler specifies the most appropriate running environment as the default selection based on the size of your job.
- For more information, see Run Job Page.
Sampling:
- Trifacta Photon also enables quick scan sampling. A quick scan sample generates an appropriate selection of rows from the dataset from which to perform the sample. These samples are faster to generate. For more information, see Overview of Sampling.
- For more information on generating samples, see Samples Panel.
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
November 18, 2020
Release 7.9
What's New
Flow View:
- Export your flows to back up your flow logic. For more information, see Export Flow.
- As needed, you can import flows back into the product. See Import Flow.
Transform Builder:
- An All option has been added for selecting columns in the Transform Builder. For more information, see Changes to the Language page.
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-55125 | Cannot copy flow. |
New Known Issues
None.
October 19, 2020
Release 7.8
What's New
Flow View:
- The viewport position and zoom level are now preserved when returning to a given flow.
Language:
- Rename columns now supports uppercase or lowercase characters or shorten column names to a specified character length from the left or right. For more information, see Changes to the Language.
Changes in System Behavior
Enhanced Flow and Flow View menu options:
The context menu options for Flow View and Flow have been renamed and reorganized for a better user experience.
- For more information, see Flows Page.
- For more information, see Flow View Page.
Key Bug Fixes
None.
New Known Issues
None.
September 21, 2020
Release 7.7
What's New
Flow View:
- Automatically organize the nodes of your flow with a single click. See Flow View Page.
Changes in System Behavior
Deprecated Parameter History Panel Feature
As a part of collaborative suggestions enhancement, the support for Parameter History panel is deprecated from the software. For more information on collaborative suggestions feature, see Overview of Predictive Transformation.
Classic Flow View no longer available
In Release 7.6, an improved version of Flow View was released. At the time of release, users could switch back to using the classic version.
Beginning in this release, the classic version of Flow View is no longer available.
Tip: The objects in your flows that were created in classic Flow View may be misaligned in the new version of Flow View. You can use auto-arrange to re-align your flow objects.
For more information, see Flow View Page.
Key Bug Fixes
None.
New Known Issues
None.
August 19, 2020
Release 7.6
What's New
In this release, experimental versions of the following have been deployed to some users of the product:
- First-time on-boarding: New and improved product walkthrough!
- Getting started workflow: Shorter and faster method for getting started wrangling data. Example datasets are available for use!
Got feedback? We'd love to hear it. Please contact Trifacta Support.
Job Execution:
Support for job cancellation. See Jobs Page.
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-48915 | Inserting special characters in an output filename results in a validation error in the the application and job failures. |
New Known Issues
None.
July 20, 2020
Release 7.5
What's New
New Flow View is now generally available:
- Drag and drop to reposition objects on the Flow View canvas, and zoom in and out to focus on areas of development.
- Perform joins and unions between objects on the Flow View canvas.
- Search for flow objects by name or by type.
Annotate the canvas with notes.
Tip: The relative position of objects on the flow view canvas is preserved between screen updates. On refresh, the window on the canvas is repositioned based on the leftmost object on the canvas to focus on the flow to other objects from that one.
NOTE: Classic Flow View is no longer available.
See Flow View Page.
Transformer Page:
Collaborative suggestions allow users within a workspace to receive suggestions based on the transformations that have been recently created by themselves or by all members of the workspace. As more users generate transformations, the relevance of these suggestions to the data in the workspace continues to improve.
For more information, see Overview of Predictive Transformation.
Language:
- New approximation functions for median, percentile, and quartile based on a very fast algorithm:
- New functions to encode and decode base64 strings.
Changes in System Behavior
Enhanced PII masking:
- For social security numbers and credit card numbers, the methods by which these values are determined for purposes of masking sensitive Personally Identifiable Information (PII) has been expanded and improved. For more information, see Improvements to the Type System.
Key Fixes
None.
New Known Issues
None.
June 22, 2020
Release 7.4
What's New
Language:
- New weekday name function.
- See Changes to the Language.
Key Bug Fixes
None.
New Known Issues
None.
June 4, 2020
Release 7.3
What's New
Language:
New rolling window date functions.
| Function Name | Description |
|---|---|
| ROLLINGMAXDATE Function | Computes the rolling maximum of date values forward or backward of the current row within the specified column. Inputs must be of Datetime type. |
| ROLLINGMINDATE Function | Computes the rolling minimum of Date values forward or backward of the current row within the specified column. Inputs must be of Datetime type. |
| ROLLINGMODEDATE Function | Computes the rolling mode (most common value) forward or backward of the current row within the specified column. Input values must be of Datetime data type. |
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-49559 | Cannot select and apply custom data types through column Type menu. |
| TD-47473 | Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted. |
| TD-34840 | Platform fails to provide suggestions for transformations when selecting keys from an object with many of them. |
New Known Issues
None.
May 18, 2020
Release 7.2
What's New
Introducing new Flow View:
The Flow View page has been redesigned to improve the user experience and overall productivity.
- Enhancements include:
- Drag and drop to reposition objects on the Flow View canvas, and zoom in and out to focus on areas of development.
- Perform joins and unions between objects on the Flow View canvas.
Annotate the canvas with notes.
Tip: The relative position of objects on the flow view canvas is preserved between screen updates. On refresh, the window on the canvas is repositioned based on the leftmost object on the canvas to focus on the flow to other objects from that one.
- You can toggle between new and classic views through the context menu in the corner of Flow View. See Flow View Page.
Language:
| Function Name | Description |
|---|---|
| KTHLARGESTDATE Function |
Extracts the ranked Datetime value from the values in a column, where |
| KTHLARGESTUNIQUEDATE Function |
Extracts the ranked unique Datetime value from the values in a column, where |
| KTHLARGESTDATEIF Function |
Extracts the ranked Datetime value from the values in a column, where |
| KTHLARGESTUNIQUEDATEIF Function |
Extracts the ranked unique Datetime value from the values in a column, where |
| MINDATEIF Function | Returns the minimum Datetime value of rows in each group that meet a specific condition. Set of values must valid Datetime values. |
| MAXDATEIF Function | Returns the maximum Datetime value of rows in each group that meet a specific condition. Set of values must valid Datetime values. |
| MODEDATEIF Function | Returns the most common Datetime value of rows in each group that meet a specific condition. Set of values must valid Datetime values. |
Changes in System Behavior
None.
Key Fixes
| Ticket | Description |
|---|---|
| TD-47473 | Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted. |
| TD-38480 | Platform fails to provide suggestions for transformations when selecting keys from an object with many of them. |
New Known Issues
None.
April 15, 2020
Release 7.1
What's New
Transformation:
- Faster and improved method of surfacing transform suggestions based on machine learning.
Language:
Some functions now accept Datetime values: Beginning in this release, the following functions now accept Datetime values as inputs. When a Datetime value is input, output values are in unixtime format.
Tip: You can wrap the unixtime format output in the DATEFORMAT function to render the results in the preferred Datetime format. See DATEFORMAT Function.
- MIN Function
- MINIF Function
- ROLLINGMIN Function
- MAX Function
- MAXIF Function
- ROLLINGMAX Function
- MODE Function
- MODEIF Function
- ROLLINGMODE Function
- KTHLARGEST Function
- KTHLARGESTIF Function
- ROLLINGKTHLARGEST Function
- KTHLARGESTUNIQUE Function
- KTHLARGESTUNIQUEIF Function
- ROLLINGKTHLARGESTUNIQUE Function
Date calculation functions:
| Function Name | Description |
|---|---|
| MINDATE Function | Computes the minimum value found in all row values in a Datetime column. |
| MAXDATE Function | Computes the maximum value found in all row values in a Datetime column. |
| MODEDATE Function | Computes the most frequent (mode) value found in all row values in a Datetime column. |
Work day functions:
| Function Name | Description |
|---|---|
| NETWORKDAYS Function | Calculates the number of working days between two specified dates, assuming Monday - Friday workweek. Optional list of holidays can be specified. |
| NETWORKDAYSINTL Function | Calculates the number of working days between two specified dates. Optionally, you can specify which days of the week are working days as an input parameter. Optional list of holidays can be specified. |
| WORKDAY Function | Calculates the work date that is before or after a start date, as specified by a number of days. A set of holiday dates can be optionally specified. |
| WORKDAYINTL Function | Calculates the work date that is before or after a start date, as specified by a number of days. You can also specify which days of the week are working days and a list of holidays via parameters. |
Time zone conversion functions:
| Function Name | Description |
|---|---|
| CONVERTFROMUTC Function | Converts Datetime value to corresponding value of the specified time zone. Input can be a column of Datetime values, a literal Datetime value, or a function returning Datetime values. |
| CONVERTTOUTC Function | Converts Datetime value in specified time zone to corresponding value in UTC time zone. Input can be a column of Datetime values, a literal Datetime value, or a function returning Datetime values. |
| CONVERTTIMEZONE Function | Converts Datetime value in specified time zone to corresponding value second specified time zone. Input can be a column of Datetime values, a literal Datetime value, or a function returning Datetime values. |
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
| Ticket | Description |
|---|---|
| TD-47473 | Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted. Workaround: Remove the space in the filename and upload again. |
March 17, 2020
Release 7.0
Numerous bug fixes and performance improvements.
What's New
Transformer Page:
- Improved performance when loading the Transformer page and when navigating between the Flow View and Transformer pages.
- Join steps are now created in a larger window for more workspace. See Join Window.
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
| Ticket | Description |
|---|---|
| TD-47473 | Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted. Workaround: Remove the space in the filename and upload again. |
February 19, 2020
Release 6.11
This release introduces in-app chat and content suggestions within the application. Give it a try!
What's New
In-app chat:
Have a question about the product? Use the new in-app chat feature to explore content or ask a question to our support staff. If you need assistance, please reach out!
Language:
New functions to parse values against specific data types:
Function Name Description PARSEBOOL Function Evaluates a String input against the Boolean datatype. If the input matches, the function outputs a Boolean value. Input can be a literal, a column of values, or a function returning String values.
PARSEFLOAT Function Evaluates a String input against the Decimal datatype. If the input matches, the function outputs a Decimal value. Input can be a literal, a column of values, or a function returning String values.
PARSEINT Function Evaluates a String input against the Integer datatype. If the input matches, the function outputs an Integer value. Input can be a literal, a column of values, or a function returning String values.
Changes in System Behavior
None.
Key Fixes
None.
New Known Issues
None.
January 23, 2020
Release 6.10
This release delivers enhancements to job monitoring, visual profiles that are downloadable in PDF format, and a useful feature to kickoff any support inquiries.
What's New
Troubleshooting:
- Encounter an issue with the product? Select Help > Report issue to collect session information for Trifacta Support. See Report Issue.
Job Details:
- When visual profiling is enabled for a job, you can now download your visual profile in PDF format. See Job Details Page.
Documentation:
- New content on the getting started with sampling. See Sampling Basics.
- Feature overview: Overview of Sampling
- Best practices: https://community.trifacta.com/s/article/Best-Practices-Managing-Samples-in-Complex-Flows
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
December 17, 2019
Release 6.9
This release introduces new statistical functions, including co-efficient and covariance calculations for enhanced analysis. A redesigned User menu facilitates easier management of user settings.
What's New
Transformer Page:
- New column selection UI simplifies choosing columns in your transformations. See Transform Builder.
Workspace:
- Redesigned Settings and Help menus. See Home Page.
- User settings are now modified through Preferences. See Preferences Page.
Language:
New statistical functions.
Function Name Description MEDIAN Function Computes the median from all row values in a column or group. Input column can be of Integer or Decimal.
PERCENTILE Function Computes a specified percentile across all row values in a column or group. Input column can be of Integer or Decimal.
QUARTILE Function Computes a specified quartile across all row values in a column or group. Input column can be of Integer or Decimal.
CORREL Function Computes the correlation coefficient between two columns. Source values can be of Integer or Decimal type.
COVAR Function Computes the covariance between two columns using the population method. Source values can be of Integer or Decimal type.
COVARSAMP Function Computes the covariance between two columns using the sample method. Source values can be of Integer or Decimal type.
Changes in System Behavior
Language:
All MODE functions return the lowest value in a set of values if there is a tie in the evaluation.
In prior releases, these functions returned a null value in the event of a tie for most common value among the evaluated ones.
- See MODE Function.
- See MODEIF Function.
- See LISTMODE Function.
- See ROLLINGMODE Function.
Key Bug Fixes
None.
New Known Issues
None.
November 13, 2019
Release 6.8
This release features enhancements to the user experience in the workspace, in the form of keyboard shortcuts and user-specific locale settings, and other useful features and improvements. Read on!
What's New
Workspace:
- Individual users can now enable or disable keyboard shortcuts in the workspace or Transformer page. See User Profile Page.
- Configure locale settings at the workspace or user level. See Locale Settings.
- You can optionally duplicate the datasets from a source flow when you create a copy of it. See Flow View Page.
- Create a copy of your imported dataset. See Library Page.
Transformer Page:
- Create a new table from selected columns, functions applied to your source, and constants to replace your current dataset. See Select.
Improved Date/Time format selection. See Choose Datetime Format Dialog.
Tip: Datetime formats in card suggestions now factor in the user's locale settings for greater relevance.
- Improved matching logic and performance when matching columns through RapidTarget. See Overview of RapidTarget.
Job execution:
If you enabled visual profiling for your job, you can download a JSON version of the visual profile. See Job Details Page.
Language:
This release introduces the sampling method of calculating statistical functions. The following are now available:
| Function Name | Description |
|---|---|
| STDEVSAMP Function | Computes the standard deviation across column values of Integer or Decimal type using the sample statistical method. |
| VARSAMP Function |
Computes the variance among all values in a column using the sample statistical method. Input column can be of Integer or Decimal. If no numeric values are detected in the input column, the function returns |
| STDEVSAMPIF Function | Generates the standard deviation of values by group in a column that meet a specific condition using the sample statistical method. |
| VARSAMPIF Function | Generates the variance of values by group in a column that meet a specific condition using the sample statistical method. |
| ROLLINGSTDEVSAMP Function | Computes the rolling standard deviation of values forward or backward of the current row within the specified column using the sample statistical method. |
| ROLLINGVARSAMP Function | Computes the rolling variance of values forward or backward of the current row within the specified column using the sample statistical method. |
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-44548 | RANGE function returns null values if more than 1000 values in output. |
New Known Issues
None.
October 9, 2019
Release 6.7
What's New
Browser:
- Support for Firefox browser. NOTE: This feature is in Beta release.
For supported versions, see Desktop Requirements.
Project Management:
- Support for export and import of macros. See Macros Page.
- For more information on macros, see Overview of Macros.
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
September 11, 2019
Release 6.6
This release introduces new functions to the language and improvements in search for transformations.
What's New
Transformer Page:
- Improvements to the Search panel enable faster discovery of transformations, functions, and other objects. See Search Panel.
Language:
| Function Name | Description |
|---|---|
| SINH Function | Computes the hyperbolic sine of an input value for a hyperbolic angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| COSH Function | Computes the hyperbolic cosine of an input value for a hyperbolic angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| TANH Function | Computes the hyperbolic tangent of an input value for a hyperbolic angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| ASINH Function | Computes the arcsine of an input value for a hyperbolic angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| ACOSH Function | Computes the arccosine of an input value for a hyperbolic angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| ATANH Function | Computes the arctangent of an input value for a hyperbolic angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
August 14, 2019
Release 6.5
This release introduces new functions and fixes a number off issues.
What's New
Language:
| Function Name | Description |
|---|---|
| SIN Function | Computes the sine of an input value for an angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| COS Function | Computes the cosine of an input value for an angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| TAN Function | Computes the tangent of an input value for an angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| Cotangent Function | See TAN Function. |
| Secant Function | See COS Function. |
| Cosecant Function | See SIN Function. |
| ASIN Function | For input values between -1 and 1 inclusive, this function returns the angle in radians whose sine value is the input. This function is the inverse of the sine function. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| ACOS Function | For input values between -1 and 1 inclusive, this function returns the angle in radians whose cosine value is the input. This function is the inverse of the cosine function. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| ATAN Function | For input values between -1 and 1 inclusive, this function returns the angle in radians whose tangent value is the input. This function is the inverse of the tangent function. The value can be a Decimal or Integer literal or a reference to a column containing numeric values. |
| Arccotangent Function | See ATAN Function. |
| Arcsecant Function | See ACOS Function. |
| Arccosecant Function | See ASIN Function. |
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
July 18, 2019
Release 6.4
This release introduces macros, which enable flexible reuse of common sequences of recipe steps.
What's New
Reuse:
- Introducing user-defined macros, which enable saving and reusing sequences of steps. For more information, see Overview of Macros.
Connectivity:
Support for direct publishing to Tableau Server. For more information, see Run Job Page.
Transformation:
- New cluster view for transforming by example. See Transformation by Example Page.
Wrangle:
- Broader support for metadata references: For Excel files,
$filepathreferences now return the location of the source Excel file. Sheet names are appended to the end of the reference. See Source Metadata References.
Changes in System Behavior
NOTE: The desktop version of Trifacta Wrangler will cease operations on August 31, 2019. If you are still using the product at that time, your data will be lost. Please transition to using the free Cloud version of Trifacta® Wrangler. Automated migration is not available. To register for a free account, please visit https://cloud.trifacta.com.
NOTE: The Chat with us feature is no longer available. For Trifacta Wrangler customers, this feature had to be enabled in the product. For more information, see Trifacta Support.
Documentation:
- In prior releases, the documentation listed UTF32-BE and UTF32-LE as supported file formats. These formats are not supported. Documentation has been updated to correct this error. See Supported File Encoding Types.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-40424 |
NOTE: Although these options are available in the application, they have never been supported in the underlying platform. They have been removed from the interface. |
New Known Issues
None.
This page has no comments.