community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

Error: "There were errors with LOADING please check your ERROR TABLES", when writing data using Output Data tool to Teradata

Error: "There were errors with LOADING please check your ERROR TABLES", when writing data using Output Data tool to Teradata.
View full article
0 Replies 1794 Views 0 likes

How to connect to SQL Server Analysis Services in Alteryx Designer

How to connect to SQL Server Analysis Services (SSAS) and extract data in Alteryx Designer.
View full article
1 Replies 3718 Views 6 likes

Error: "Error while trying to retrieve text for error ORA-12705" when adding multiple IN-DB tools to different Oracle databases

The message, "Error while trying to retrieve text for error ORA-12705" occurs when using multiple IN-DB tools to different Oracle connections.
View full article
0 Replies 2273 Views 0 likes

Alteryx doesn't read some unicode characters correctly

Alteryx doesn't read some unicode characters correctly
View full article
0 Replies 818 Views 1 likes

Error: "ORA-00900: invalid SQL Statement" when executing a procedure in the Pre/Post SQL Statement section

Error: "ORA-00900: invalid SQL Statement" occurs when running a procedure in the Pre or Post SQL Statement for Input or Output Data tools.
View full article
1 Replies 7184 Views 2 likes

Error: Unknown function YEAR()

Troubleshooting the "Unknown Function YEAR()" error, or other related Date expressions.
View full article
1 Replies 1415 Views 1 likes

Error: "The account is locked" when running a workflow after a database password has changed

Error: "The account is locked" when running a workflow after a database password has changed.
View full article
0 Replies 2100 Views 0 likes

Snowflake External Tables are not showing in the Alteryx Visual Query Builder tab

Snowflake External Tables are not showing in the Alteryx Visual Query Builder tab.
View full article
0 Replies 931 Views 0 likes

Error: "Input Data (1): Error SQLExecute: No active warehouse selected in the current session." while trying to connect to Snowflake from Input Data Tool

While trying to connect to Snowflake from Alteryx Designer, using Input Data tool, the following error is thrown after running the workflow: Error: Input Data (1): Error SQLExecute: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
View full article
1 Replies 5523 Views 0 likes

Numeric values show "[Null]" instead of a blank cell using the Input Data tool

Numeric values show "[Null]" instead of a blank cell using the Input Data tool.
View full article
0 Replies 1127 Views 1 likes

App is not showing completely

Alteryx app (.yxwz) is not showing up completely, with missing controls.
View full article
0 Replies 815 Views 0 likes

Thai characters are not showing up correctly

Importing Thai data from Oracle Database using Oracle ODBC driver is displaying the Thai characters as garbled characters in Alteryx. This can be addressed by setting a parameter in the driver to unconditionally change the data type to support Unicode.
View full article
0 Replies 1547 Views 1 likes

Error with environment variables: os.environ['PATH'] - Image Template Tool

Environment variable issue with the os.environ['PATH'] error
View full article
0 Replies 1364 Views 0 likes

Data types W_String or VW_String are not available for Flat File ASCII files

Data types W_String or VW_String are not available for Flat File ASCII files.
View full article
1 Replies 1406 Views 0 likes

Error: "ORA-21500: internal error code, arguments: [%s], [%s], [%s]" when pulling Spatial data from Oracle using Input data tool

Error: "ORA-21500: internal error code, arguments: [%s], [%s], [%s]" when pulling Spatial data from Oracle using Input data tool.
View full article
1 Replies 1568 Views 0 likes

Error: "HTTP Error 403: Forbidden", when using Output Data tool to Hive HDFS in an encrypted zone

Error: "HTTP Error 403: Forbidden", when using Output Data tool to Hive HDFS in an encrypted zone.
View full article
0 Replies 1531 Views 0 likes

In-DB tools add a SELECT statement to Common Table Expression (CTE) queries

In-DB tools add a SELECT statement to Common Table Expression (CTE) queries.
View full article
2 Replies 3183 Views 3 likes

Connecting to an Oracle database causes Designer to get stuck in "Not Responding"

Connecting to an Oracle APPS schema causes Designer to get stuck in "Not Responding".
View full article
0 Replies 1962 Views 1 likes

How to add an example link in the custom tool

The article provides the steps to add in an example in the custom tool
View full article
1 Replies 2377 Views 3 likes

Error: "An Item with the Same Key has already been added" with Sharepoint List Input Tool

Error: "An Item with the Same Key has already been added" with Sharepoint List Input Tool
View full article
2 Replies 4337 Views 0 likes

Error: "ORA-12592: TNS:Bad Packet Error" occurs when running a workflow

Error: "ORA-12592 TNS Bad Packet Error" occurs when running a workflow.
View full article
0 Replies 12712 Views 1 likes
Labels