Contents:
October 19, 2020April 15, 2020
Release 7.8Release 7.1
What's NewWhat's New
Flow View:Transformation:
- The viewport position and zoom level are now preserved when returning to a given flow.Faster and improved method of surfacing transform suggestions based on machine learning.
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.
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.
June 17, 2019
Release 6.3
This release features a brand-new way to develop transformations via example. Map source column values to your entered values, and the platform can infer similar pattern-based matches in your column of data. Also, multi-step operations are now available in the Recipe panel. For administrators: you can now review the list of all available schedules in the workspace.
What's New
- Transform by example output values for a column of values. See Overview of TBE.
Transform:
- The redesigned Recipe panel enables multi-step operations and more robust copy and paste actions. See Recipe Panel.
Language:
Changes to System Behavior
NOTE: The Chat with us feature is no longer available. For more information, see Trifacta Support.
Key Bug Fixes
None.
New Known Issues
None.
May 15, 2019
Release 6.2
This release includes new functions and a new method for locating datasets and recipes to join in.
What's New
Transformer Page:
- Browse current flow for datasets or recipes to join into the current recipe. See Join Window.
Language:
New functions:
Function Name Description RANK Function Computes the rank of an ordered set of value within groups. Tie values are assigned the same rank, and the next ranking is incremented by the number of tie values.
DENSERANK Function Computes the rank of an ordered set of value within groups. Tie values are assigned the same rank, and the next ranking is incremented by 1.
Connectivity:
- Enhanced import process for Excel files. See Import Excel Data.
Changes to System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
April 10, 2019
Release 6.1
This introduces new selection-specific operations, including replacement of individual cell values, as well as bug fixes.
What's New
Wrangling:
- Replace specific cell values. See Replace Cell Values.
Changes to System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
March 4, 2019
Release 6.0
This release of Trifacta® Wrangler introduces key features around job monitoring and column management, including multi-select and copy and paste of columns and column values. A new Job Details page captures more detailed information about job execution and enables more detailed monitoring of in-progress jobs.
What's New
NOTE: The PNaCl client for Google Chrome has been replaced by the WebAssembly client. This new client is now the default in use by the platform and is deployed to all clients through the browser. Please verify that all users are on Google Chrome 68+. For more information, see Desktop Requirements.
Wrangling:
- In data grid, you can select multiple columns before receiving suggestions and performing transformations on them. For more information, see Data Grid Panel.
- New Selection Details panel enables selection of values and groups of values within a selected column. See Selection Details Panel.
- Copy and paste columns and column values through the column menus. see Copy and Paste Columns.
- Support for importing files in Parquet format. See Supported File Formats.
Monitoring:
- Monitor the status of in-progress jobs through the new Job Details page. See Job Details Page.
Wrangle :
New functions:
Function Name Description ARRAYINDEXOF Function Computes the index at which a specified element is first found within an array. Indexing is left to right.
ARRAYRIGHTINDEXOF Function Computes the index at which a specified element is first found within an array, when searching right to left. Returned value is based on left-to-right indexing.
ARRAYSLICE Function Returns an array containing a slice of the input array, as determined by starting and ending index parameters.
ARRAYMERGEELEMENTS Function Merges the elements of an array in left to right order into a string. Values are optionally delimited by a provided delimiter.
- The LISTUNIQUE function is now the UNIQUE Function.
- All
LIST*functions now accept Array type only inputs.
Changes to System Behavior
$filepath disabled
In a prior release, the $filepath reference was enabled in
Trifacta Wrangler. Since all file paths are to the local desktop, this reference is considered unreliable. It has been disabled for use in this version and subsequent versions of the product.
NOTE: If your recipes contain references to $filepath in them, they are broken in the new version of the product. Please review your recipes in the Transformer Page to see if specific steps are broken.
Key Bug Fixes
None.
New Known Issues
| Ticket | Description |
|---|---|
| TD-38869 | Upload of Parquet files does not support nested values, which appear as null values in the Transformer page. Workaround: Unnest the values before importing into the platform. |
February 5, 2019
What's New
NOTE: The PNaCl client for Google Chrome has been replaced by the WebAssembly client component. This new client is now the default in use by the platform and is deployed to all clients through the browser. For more information, see Desktop Requirements.
Wrangling:
- Standardize column values through a simple new interface. See Standardize Page.
- For more information on other methods of standardization, see Overview of Standardization.
Workspace:
New functions:
The following functions can now be applied directly to arrays to derive meaningful statistics about them.
Function Description ARRAYSORT Function Sorts array values in the specified column, array literal, or function that returns an array in ascending or descending order.
TRANSLITERATE Function Transliterates Asian script characters from one script form to another. The string can be specified as a column reference or a string literal.
Changes to System Behavior
None.
Errata
In prior releases, the product and documentation stated that the platform implemented a version of regular expressions based on Javascript syntax. This is incorrect.
The platform implements a version of regular expressions based off of RE2 and PCRE regular expressions.
NOTE: This is not a change in behavior. Only the documentation has been changed.
Key Fixes
None.
New Known Issues
None.
January 10, 2019
What's New
Language:
- New functions to compute statistics on arrays.
- Track file-based lineage using
$filepathand$sourcerownumberreferences. See Source Metadata References.
Jobs:
- Filter list of jobs by source of job execution or by date range. See Jobs Page.
Changes to System Behavior
None.
Key Fixes
None.
New Known Issues
None.
December 4, 2018
This release includes one new feature and a number of updates to address issues in the platform.
What's New
NOTE: Beginning in this release, Trifacta® Wrangler utilizes the WebAssembly client extension in Google Chrome. This replaces the PNaCl client extension, which was used in earlier releases. No configuration is required. For more information, see Desktop Requirements.
- Organize your flows into folders. See Flows Page.
Changes to System Behavior
None.
Key Fixes
| Ticket | Description |
|---|---|
| TD-36332 | Data grid can display wrong results if a sample is collected and dataset is unioned. |
| TD-36192 | Canceling a step in recipe panel can result in column menus disappearing in the data grid. |
New Known Issues
None.
October 24, 2018 Update
This release is primarily focused on fixing issues in the platform.
What's New
None.
Changes to System Behavior
None.
Key Fixes
| Ticket | Description |
|---|---|
TD-35504 | Cancel job throws 405 status code error. Clicking Yes repeatedly pops up Cancel Job dialog. |
TD-35481 | Recipe is malformed after software update. |
New Known Issues
None.
October 2, 2018 Update
What's New
Tip: For a general overview of the product and its capabilities, see Product Overview.
Transformer Page:
- Updated toolbar. See Transformer Toolbar.
- Enhanced options in the column menu. See Column Menus.
Jobs:
- Filter list of jobs by date. See Jobs Page.
Language:
- Rename columns using values across multiple rows. See Rename Columns.
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-34472 | Splitting a column on multiple pattern yields an error in the Transformer page. |
| TD-31252 | Assigning a target schema through the Column Browser does not refresh the page. |
New Known Issues
| Ticket | Component | Description |
|---|---|---|
| TD-34840 | Transformer Page | Platform fails to provide suggestions for transformations when selecting keys from an object with many of them. |
August 30, 2018 Update
What's New
Transformations:
| Transformation Name | Description |
|---|---|
| Bin column | Place numeric values into bins of equal or custom size for the range of values |
| Scale column | Scale a column's values to a fixed range or to zero mean, unit variance distributions. |
| One-hot encoding | Encode values from one column into separate columns containing 0 or 1, depending on the absence or presence of the value in the corresponding row. |
| Group By | Generate new columns or replacement tables from aggregate functions applied to grouped values from one or more columns. |
Publishing:
- Add quotes as CSV file publishing options. See Run Job Page.
Changes to System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-34407 | Profile job fails due to Out of Memory error. |
| TD-34390 | Profile job fails with bigger than spark.driver.maxResultSize error. |
| TD-34389 | Transform job fails when sorting on a Boolean column. |
| TD-33428 | Job execution on recipe with high limit in split transformation due to Java Null Pointer Error during profiling. NOTE: Avoid creating datasets that are wider than 2500 columns. Performance can degrade significantly on very wide datasets. |
| TD-33744 | If you cancel out of a previewed join, the previewed dataset remains in the flow. |
New Known Issues
None.
July 30, 2018 Update
What's New
Transformer Page:
- Join tool is now integrated into the context panel in the Transformer page. See Join Window.
Patterns are available for review and selection, prompting suggestions, in the context panel.
Changes to System Behavior
New Functions
| Function Name | Description |
|---|---|
| DOUBLEMETAPHONE Function | Returns a two-element array of primary and secondary phonetic encodings for an input string, based on the Double Metaphone algorithm. |
| DOUBLEMETAPHONEEQUALS Function | Compares two input strings using the Double Metaphone algorithm. An optional threshold parameter can be modified to adjust the tolerance for matching. |
Key Bug Fixes
None.
New Known Issues
| Ticket | Component | Description |
|---|---|---|
| TD-33744 | Transformer Page - Tools | If you cancel out of a previewed join, the previewed dataset remains in the flow. Workaround: Remove the previewed dataset through Flow View. |
June 26, 2018 Update
What's New
- Samples can be named. See Samples Panel.
Changes to System Behavior
SOURCEROWNUMBER function generates null values consistently
The SOURCEROWNUMBER function returns the row number of the row as it appears in the original dataset. After some operations, such as unions, joins, and aggregations, this row information is no longer available.
Previously, the results were confusing. When source row information was not available, the function was simply not available for use.
Now, the behavior of the SOURCEROWNUMBER function is more consistent:
- If the source row information is available, it is returned.
- If it is not available:
- The function can still be used.
- The function returns null values in all cases.
For more information, see SOURCEROWNUMBER Function.
New Functions
| Function Name | Description |
|---|---|
| UNIQUE Function | Generates a new column containing an array of the unique values from a source column. |
Key Bug Fixes
None.
New Known Issues
None.
May 29, 2018 Update
In this release Trifacta Wrangler Enterprise has been enhanced with account monitoring capabilities, so you are alerted when you are approaching data usage and job execution limits. As needed, you can remove objects from the platform to reduce your current usage. Read below for details.
What's New
Account Management:
- Review your storage and download volumes for the current month. See Data Usage Page.
Transformer Page:
- Improved join inference key model. See Join Window.
Publishing:
- Export snapshot of a flow for completed jobs. See Flow View Page.
Changes to System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-31626 | Adding join keys does not refresh join preview pane. |
| TD-31264 | Patterns not available for Datetime columns |
New Known Issues
| Ticket | Component | Description |
|---|---|---|
| TD-31343 | Connectivity | Upload of XSLX appears to fail. Tip: XLSX file upload is currently slow. Please be patient with the upload process. This area is targeted for improvements in a future release. |
April 2, 2018 Update
Welcome to the inaugural release of the cloud version Trifacta® Wrangler! This release represents the migration of the prior version of Wrangler for the desktop to the cloud, where you can take advantage of more storage and faster processing.
NOTE: As of this release, the desktop version of Trifacta Wrangler is no longer updated. You can continue to use the product for a period of time. However, at some point in the future, this product will be terminated and no longer accessible.
At this time, you should migrate to using the cloud version of Trifacta Wrangler. This new product contains the latest features from Trifacta and will be the supported version going forward.
This page has no comments.