Alteryx Designer Knowledge Base

Error: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" when connecting to Oracle.

During run time of workflow, the following error is received:

Database aliases can help users save time and allow easier sharing of data. Let's take a look at how. The first step to creating a database alias in Designer is to establish the database connection.

Simple fix when receiving an encoding error in a PostgreSQL connection

This is a workaround for connecting to an Oracle database that uses LDAP authentication.

The guide covers SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, CROSS JOIN, WHERE BETWEEN, WHEREIN, DISTINCT and we hope you find it helpful.

How to collect Wireshark traces to troubleshoot network-related issues.

Steps to troubleshooting an "Unhandled Exception" error when attempting to open the Manage Data Connections window.

How To: Gather ODBC Logs for troubleshooting

When running a workflow via the Scheduler (for Designer with Automation), the following error is observed:

Setting up Connection Files on a Network Share

How To: Create an In-Database Connection

Learn about upcoming changes to Alteryx support of 32-bit database connections and start planning today

Error experienced with Impala Driver: [Cloudera][ImpalaODBC] (450) Error when calling the Impala Thrift API ExecuteStatement: SSL_read: error code: 0 when attempting to connect. This error is thrown by the DB driver if a connection is taking too long. It is common for it to be experienced intermittently.

Receive "ERROR: The session is read-only" using pre/post SQL option in the Input Data tool when attempting to perform any operation that is not a select statement, such as dropping/creating tables

Select Tool fields show as missing & data types show unknown when querying from a database

Sometimes you only need to read in specific fields from a database or input. Within Alteryx it is as easy as using a Formula tool, Dynamic Rename and Dynamic input!!   The first step is to bring in the master file and the list of field names you wish to carry through from the Master file.   Next attach a formula tool to the field names list and create a new field with the expression "Keep-" + [FieldNames].     This will rename the fields with “Keep-” appended to the field name.   The next step is to use a dynamic rename tool to “Take Field Names from Right Input Rows”. In the 'New Field Name from Column" select the field which has just been created above.   Use a dynamic select tool to ‘Select via a formula’ and use the expression below to find the field which has ‘Keep-“ appended to the left hand side.  This will then only bring through the specific fields from the Master file which you have listed in the field name input.    Using a dynamic rename you can return the fields to their original names through a substring function. This will remove the "Keep-" from the field name.       You now just have the fields you want from the Master input file!      Jordan Barker Client Service Representative

Have you ever wanted to enrich your marketing data through improved data blending and analytics. Now is your chance by connecting to Oracle Eloqua through Alteryx!

Need more information on how to use our visual query builder when choosing tables or queries to input? We’ve put together a quick video in v10.1 for your reference:   https://www.youtube.com/watch?v=fJjAiAHtCuc   Find more information on our visual query builder below: http://help.alteryx.com/current/index.htm#ChooseTableorSpecifyQuery.htm#Visual    

Unable to find the dll: "OCI.dll" Within Alteryx this error will be prompted due to a mismatch between 32/64 bit drivers and the Alteryx bit version. This error may also appear if you do not have the drivers installed. One way to troubleshoot this is to find out what drivers you have installed! You can use an input tool in the Alteryx Designer, go to Other Databases and select either ODBC/OleDB (64-bit) or 32-Bit Database Connections -> ODBC/OleDB. In the next pop out window it will populate with the available drivers for those connections. If you have no drivers in this pop out window this means you do not havethe correct drivers for 32 bit or 64 bit connection dependent upon which one you chose. Links to drivers are available from within individual data source pages here. This will take you away from the Alteryx website and onto the driver provider’s pages. Please consult with your IT to find the correct drivers for your environment.

This is the third article in the series of renaming, moving, and deleting files using a batch file. This workflow will create a .bat file which you can use in other workflows that use the files you specify in this workflow to delete files.   WARNING: Please be careful using this command as it will do what it says it will do. Test thoroughly before adding to production.   Deleting Files   Creating the Batch file workflows: Tools needed: (1)Directory Input, (2)Select, (3)Formula, (4)Summarize, (5)Output Tools.   Directory Tool (1) – Browse to the file or files you are looking to change   Select Tool (2) – Fields you will need are Fullpath, Directory, and File Name   Formula Tool (3) – Output Fields Created: Command and Batch File. Create a new field, Command (String) – This is the field you want to build your command. Expression: 'DEL '+ '"'+[FullPath]+ '"'+ ' ' + + '"'+[FileName]+ '"' Sample Output - DEL "C:\Users\dmenke\Documents\Sample Data\Command Line Test\$200.xlsx" "$200.xlsx" Create a new field,   Batch File (String) – You will take the Directory field from the Directory Input and add a name of what you want the Batch File to be. Expression: [Directory]+’Delete_files.bat' Sample Output - C:\Users\JDoe\Documents\Sample Data\Command Line Test\rename_files.bat Summarize Tool – Select the Command field and the action will be to concatenate using a separator as \n. Select the Batch file and the action will be First. You can rename the Output fields if you choose as it will change the fields to Concat_Command and First Batch File.   Output Tool (5) – Browse to save file as any name you want (you will be replacing this name). You will want to use the Save as type: (.csv) and add .bat to end of the name. We want to transform that txt file to a bat file. In the Delimiters Row in the Options section add \0 as the delimiter. Select Take/Table Name From Field and choose Change Entire File Path. Select the First_Batch file (or name you called the field) in the Field Containing File Name or Part of File Name and unselect Keep Field in Output.     Adding Batch File to Your Workflow: The last step is to add this batch file to the Events tab in a Workflow that you want to move the file or files you have chosen in the .bat file in the Configuration window. Select Add > Run Command> Run Event When> After Run> Command: Browse to the bat file and click Ok.   See attached Sample Workflow.