...
None.
New Known Issues
None.
...
November 18, 2020
Release 7.8Release age7 p.19
What
...
'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:
...
- 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.
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.
- Flow View Page
Key Bug Fixes
...
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 |
---|
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
d-s-experimental |
---|
In this release, experimental versions of the following have been deployed to some users of the product:
|
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 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.
Info 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 |
| ||||||
ROLLINGMINDATE Function |
| ||||||
ROLLINGMODEDATE Function |
|
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.
D beta |
---|
- 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 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 |
| ||||||
KTHLARGESTUNIQUEDATE Function |
| ||||||
KTHLARGESTDATEIF Function |
| ||||||
KTHLARGESTUNIQUEDATEIF Function |
| ||||||
MINDATEIF Function |
| ||||||
MAXDATEIF Function |
| ||||||
MODEDATEIF Function |
|
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.
...
Function Name | Description | ||||||
---|---|---|---|---|---|---|---|
CONVERTFROMUTC Function |
| ||||||
CONVERTTOUTC Function |
| ||||||
CONVERTTIMEZONE Function |
|
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.
|
...
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.
|
...
This release introduces in-app chat and content suggestions within the application. Give it a try!
What's New
In-app chat:
Tip |
---|
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! |
...
New functions to parse values against specific data types:
Function Name Description PARSEBOOL Function D excerpt include page PARSEBOOL Function nopanel true PARSEFLOAT Function D excerpt include page PARSEFLOAT Function nopanel true PARSEINT Function D excerpt include page PARSEINT Function nopanel true
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
. See Report Issue.D s support
...
- 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.
...
New statistical functions.
Function Name Description MEDIAN Function D excerpt include page MEDIAN Function nopanel true PERCENTILE Function D excerpt include page PERCENTILE Function nopanel true QUARTILE Function D excerpt include page QUARTILE Function nopanel true CORREL Function D excerpt include page CORREL Function nopanel true COVAR Function D excerpt include page COVAR Function nopanel true COVARSAMP Function D excerpt include page COVARSAMP Function nopanel true
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.
...
- 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.
...
Function Name | Description | ||||||
---|---|---|---|---|---|---|---|
STDEVSAMP Function |
| ||||||
VARSAMP Function |
| ||||||
STDEVSAMPIF Function |
| ||||||
VARSAMPIF Function |
| ||||||
ROLLINGSTDEVSAMP Function |
| ||||||
ROLLINGVARSAMP Function |
|
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.
D beta
For supported versions, see Desktop Requirements.
...
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.
...
Function Name | Description | ||||||
---|---|---|---|---|---|---|---|
SINH Function |
| ||||||
COSH Function |
| ||||||
TANH Function |
| ||||||
ASINH Function |
| ||||||
ACOSH Function |
| ||||||
ATANH Function |
|
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 |
| ||||||
COS Function |
| ||||||
TAN Function |
| ||||||
Cotangent Function | See TAN Function. | ||||||
Secant Function | See COS Function. | ||||||
Cosecant Function | See SIN Function. | ||||||
ASIN Function |
| ||||||
ACOS Function |
| ||||||
ATAN Function |
| ||||||
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.
...
- Broader support for metadata references: For Excel files,
$filepath
references 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
Info | ||||||
---|---|---|---|---|---|---|
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
|
...
- 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 |
|
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.
...
Info | |
---|---|
NOTE: The Chat with us feature is no longer available. For more information, see
|
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.
...
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
D s product | ||
---|---|---|
|
What's New
Info |
---|
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. |
...
Info |
---|
NOTE: If your recipes contain references to |
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.
|
February 5, 2019
What's New
Info |
---|
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.
...
Info |
---|
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
$filepath
and$sourcerownumber
references. See Source Metadata References.
...
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
Info | ||||||
---|---|---|---|---|---|---|
NOTE: Beginning in this release,
|
- 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 |
---|
Tip: For a general overview of the product and its capabilities, see Product Overview. |
...
- 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. |
...
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.
| ||
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.
...
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.
...
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
D s product | ||
---|---|---|
|
What's New
Account Management:
- Review your storage and download volumes for the current month. See Data Usage 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.
|
...
At this time, you should migrate to using the cloud version of
D s product | ||
---|---|---|
|
D s company |
---|