Release Date: September 3, 2019
After you export results of a Browse tool to a file, you can click the hyperlink in the pop-up window to view that file.
The Input Data tool can be converted to a Dynamic Input tool through the Context menu.
The Output Data tool can be converted to an Input Data tool through the Context menu.
You can now save the Browse tool as an Output Data tool page or a Macro Output tool.
The Browse tool configuration window displays the Sum for numeric columns when data profiling is enabled.
Calgary tools include file names in annotations like the other input and output tools.
- The Email tool no longer auto detects SMTP authentication. To use SMTP authentication, you can manually configure it.
New one-tool examples for spatial: There are thirteen new, one-tool examples including Buffer, Create Points, Find Nearest, Generalize, Heat Map, Make Grid, Poly Split, Poly Build, Spatial Info, Smooth, Spatial Match, Spatial Process, and Trade Area.
- Designer now has a beta version of Italian available.
The autorecover feature automatically recovers your files in Designer.
The Results window (located at the bottom of your workflow) is now even more interactive. By clicking on a column headers' ellipses and selecting to Sort and/or Filter, you can add the tool(s) to your workflow by clicking on the icon at the top, far-right of the Results window. Click Revert to Original in the icon's drop-down to go back to your Results window's original state.
If you have more than one version of your macro, you can view which version of the macro is used through the Context menu.
You can enable and disable the sound that plays when a workflow completes. In the User Settings menu, select Play Sound at Completion of Workflow.
You can drag and drop a folder from Windows File Explorer directly onto the canvas to create a Directory.
Overview window enhancements:
- The Overview window now shows you at a glance what tools have finished running.
- Double-click anywhere in the Overview window when you are zoomed out to zoom in again.
Press the space bar to close the Finished running window.
If you clear an annotation for a file, it reverts to the original file name.
Designer now recognizes text (.txt) files when you drag and drop them onto the canvas.
A blue border now appears when you select the comment box.
When Designer is closed with any unsaved workflows, a prompt appears with options to save any unsaved workflows.
Added a new Predictive Tools Locale/Codepage option in User Settings that enables you to use R based predictive tools when needing to treat multi-byte character data.
When copying and pasting tools, you can now simply point to the canvas and Designer will paste the tool there.
|DE12778||Bugs and inefficiencies with Multi-Field Binning Macro.||Fixed|
|DE13352||AWS Aurora MySQL Append Existing downloads all records before insert.||Fixed|
|DE13841||Error using spatial objects with SQL Server.||Fixed|
|DE16707||Japanese Characters in Temp Render Output.||Fixed|
|DE17584||Issue connecting to S3 bucket endpoint for China.||Fixed|
|DE17686||Render Tool output is cut off information.||Fixed|
|DE17845||Error when writing to Oracle and running a query with a WHERE condition filtering on accented characters.||Fixed|
|DE18181||R Tool: Unicode and Shift-JIS from R causes a garbled message in the message pane.||
|DE18252||The connection progress boxes do not move when tools are moved.||Fixed|
|DE18650||Issue writing CLOB data types to Oracle via ODBC and OCI.||Fixed|
|DE18722||ARIMA tool does not output results properly when using Japanese user interface.||Fixed|
|DE19021||Unable to finish a dialog at completion of a workflow.||Fixed|
|DE19086||Column name encoding issue in R tool - Japanese column names turn to "X....".||Fixed|
|DE19196||Issue loading the Designer product walkthrough while using the single point of access.||Fixed|
|DE19404||Macros run the quick configuration on every keyboard move.||Fixed|
|DE19436||The disable button of containers is still enabled in nested collapsed containers.||Fixed|
|DE19456||Opening a second workflow from the file explorer causes Designer to crash.||Fixed|
|DE19498||Issue writing large data sets to SharePoint Online lists.||Fixed|
|DE19680||Dynamic Rename cannot attain new fields when using analytic app.||Fixed|
|DE19834||Not interpreting Dynamic/Unknown field issue in the Japanese user interface.||Fixed|
|DE19852||Designer does not open for some users after upgrading to version 2019.2.||Fixed|
|DE20103||Unable to launch System Settings on localized installs 2019.2.||Fixed|
|DE20757||The number of tiles selector doesn't work if "equal sum" or "equal records" are selected as the tile method in the tile tool in 2019.2.7.||Fixed|
|DE19142||When a French user tries to import an excel sheet that is currently open on the users machine, an error is thrown.||Known|
|DE19269||Python tool does not work from Designer instance started from installer.||Known|
|DE19176||Designer crashes when limit keyword is used in the Data Input tool.||Known|
|DE19293||Configurations panel disappears after "Run as analytic app" is clicked.||Known|
|DE19298||Join in MySQL not properly reading in spatial data.||Known|
|DE19299||Join in Netezza not properly reading in spatial data.||Known|
|DE19300||Join in Postgres not properly reading in spatial data.||Known|
|DE19304||Redshift/Snowflake Bulk overwrite 'new' table fails with append option.||Known|
|DE19391||Adobe Analytics connector references the wrong directory for supporting macros.||Known|
|DE19396||Workflow with Connection Downloaded from Connect cannot be published to Gallery.||Known|
|DE19397||"Choose Table" window repeats object name 15+ times.||Known|
|DE19408||InDB Filter 'Does Not Equal' broken for Teradata.||Known|
|DE19455||Slow performance with the Spark Code tool when outputting data.||Known|
|DE19541||Error reading in data from Snowflake if scale for fixed decimal is zero.||Known|
|DE19569||The Azure Data Lake File Output tool does not report success in Results panel of Designer.||Known|
|DE19572||Azure Data Lake traceback error when writing with Avro format.||Known|
|DE19575||The Azure Data Lake File Output can select a file made by another user, but when they try to overwrite they get traceback error.||Known|
|DE19636||Tools are removed from tool container when tool containers are nested.||Known|
|DE19709||Reading NCLOBs with OCI truncates data.||Known|
|DE19855||The Allocate macro causes Alteryx to throw an exception.||Known|
|DE19954||Code is executing in Jupyter notebook after it has been deleted. This is an artifact of Jupyter nbconvert. Users must execute the cells in the Jupyter notebook.||Known|
|DE20000||Alteryx no longer remembers the last file extension saved.||Known|
|DE20038||Incorrect default port for Hadoop 3.0.||Known|
|DE20055||Issue accessing an HDFS filepath from Alteryx.||Known|
|DE20061||The version of Numpy/OpenBlas that Designer uses in 19.2 and 19.3 will cause issues for Designer when trying to use a Python tool. Contact customer support for a resolution.||Known|
|DE20074||Python tool on new workflow shows code from previous workflow.||Known|
|DE20090||Big Query connector failing on Decimal/Numeric types.||Known|
|DE20249||For SQL Server, fields disappear from the Visual Query Builder when using (nolock) statement in SQL editor.||Known|
|DE20301||Broken Download predictive link is not localized.||Known|
|DE20320||Unable to open the macro workflow because of an error.||Known|
|DE20351||Wizard (App Interface) button in toolbar disappears after resetting to defaults.||Known|
|DE20356||Listbox interface tool should not have an 'Include [None]' checkbox option.||Known|
|DE20384||Python installer fails with long path error for Azure Data Lake Input/Output tools.||Known|
|DE20430||Yxdb viewer appears behind Designer main window when opening.||Known|
|DE20501||Date dropdown in the Summarize tool is not wide enough to read fields.||Known|
|DE20502||Connection manager files does not accept .txt, .dat, .asc, .log files for drag and drop.||Known|
|DE20511||Connection Status not moving for some tools.||Known|
|DE20549||Directory tool updates meta info very slowly.||Known|
|DE20555||Python tool crashes on PC that supports AVX-512 architecture.||Known|
|DE20566||Find Tool dialog does not handle up and down arrows intelligently.||Known|
|DE20577||Snap to Grid does not work properly with containers.||Known|
|DE20629||Visual Query Builder window is opening and not closing the database connection.||Known|
|DE20649||Syntax highlighting for Annotation (CData) stops syntax highlighting.||Known|
|DE20656||Data Profile Chart has incorrect messaging.||Known|
|DE20750||Input Data annotation shows a large SQL query in the annotation.||Known|
|DE20751||Connect In-Db annotations show a large SQL query instead of 'Table' or 'Query'.||Known|
|DE20752||Exception when pasting in R Tool, XML editor, SQL editor, when FIPS is enabled.||Known|
|DE20753||Copy/Paste can freeze the R tool, SQL editor and XML editor.||Known|
|DE20813||The Arima tool now supports multi-byte character data, however, the code page selected needs to be Western European, no matter what language is installed.||Known|
Product Compatibility and Version Support Policy