To get back a window that you may have accidentally closed, such as the Configuration window for example, go to View and select the Configuration window or the window you are missing.
You can double-click or right-click any tool and the Configuration window will become an active visible window.
You can return to the default window settings at any time by going to Options > User Settings > Restore Defaults. This will dock the windows in the original orientation from the default Alteryx setting.
There are a few ways to turn annotations on and off.
Per Tool: You can turn them on or off per tool, meaning you want to keep some annotations while omitting others. To do this click on the individual tool. Go to Annotation from the Properties window and in the Display Mode, select the appropriate choice.
Per Workflow: There is a toggle switch on the Workflow Configuration window where you can either turn all the annotations on or off for that particular workflow. Additionally you can have greater control leaving this feature on and controlling the annotations per tool as described above.
Through User Settings: You can set up your user settings so that Annotations will appear the same way for every workflow and tool.
See User Settings, Tool Configuration, and Workflow Configuration for more information on annotations.
Use the PadLeft(String, len, char) function, which pads the string to the left with the specified character to the specified length.
When you output to a spatial file be sure you are outputting a spatial object with the output.
Select the Output Data tool. From the Properties window, click on Configuration and specify the file name, type and location you are outputting to.
Once you click save, an Advanced Options grid will appear in the Configuration Properties. In the second row of the grid choose the appropriate spatial object you would like the output layer to contain.
While using spatial tools, you may have more than one spatial object field in the data stream. When you are configuring the final Output Data tool, you must remember that spatial files will accept only one spatial object field.
The Transpose and CrossTab tools are alike in that they both transform the orientation of your data, but are opposite in their behavior.
The Transpose tool pivots horizontal data to a vertical axis. The CrossTab performs the reverse, pivoting vertical data to the horizontal axis, by summarizing the data on a grouping field.
See the Transpose Tool and Cross Tab Tool pages for more information.
Se Functions for examples on creating expressions for strings.
The nice thing about the Union Tool is you have complete control over how the fields will line up.
In this situation, let Designer get you most of the way there. When you hook up a Union tool, select the radio button Auto Config by Name.
From the Configuration Properties, the Manually Config setting allows you to specify the field order individually. Note: when the mode is set to Manual Config, Designer assumes the configuration will not change at runtime. Therefore if anything is missing, an error is thrown. Be careful to keep this configuration mode out of Analytic App/Macro actions.
To reorder the way the columns stack, click inside a field and click the arrows to relocate the column.
Another way is to hook each input to a Select Tool and rename the fields before passing them through the Union tool.
Multiple files can be brought through a single input file. When configuring the input file, browse to the file path and type in as much of the name as the files all have in common followed by a * to recognize multiple characters
This example brings in every.csv file contained within the data\datafile directory whose name begins with ABCD no matter how many characters follow in the field name. So it will bring in ABCD_4.csv and ABCD012.csv.
Use ? to recognize one character. Remember to include the file extension.
This example brings in every.csv file contained within the data\datafile directory whose name begins with ABCD_ + 1 character. So it will bring in ABCD_4.csv but not ABCD_012.csv.
See Input Data Tool.
Primarily the best place to rename a field is through the Select Tool.
There are a number of tools that have an embedded select within the tool. Therefore you can rename a field there as well. Tools that contain an embedded select are: Join Tool, Join Multiple Tool, Append Fields Tool, Spatial Match Tool, and Find Nearest Tool.
Primarily the best place to change a field's type is through the Formula Tool. There is more control for custom conversion through the formula tool.
The next best place to change a field's type is the Select Tool or, there are a number of tools that have an embedded select within the tool. Therefore you can change a field's type there as well. Tools that contain an embedded select are: Join Tool, Join Multiple Tool, Append Fields Tool, Spatial Match Tool, and Find Nearest Tool.
There are a couple of ways to optimize a workflow to speed up the time it takes to run a workflow.
The #1 way to speed up processing time is to use Select Tool to remove fields you are not using as early as possible in a stream.
Minimize the time it takes to process and initialize spatial data by writing to *.yxdb files. Any spatial file that will remain static should be sorted on the spatial object and then outputted to an *yxdb file. Such as in the case of using the Spatial Match Tool, you can bring in the *.yxdb file directly and will bypass the backend process of reading in and sorting the spatial file.
The Dynamic/Unknown field shows up and is checked by default in the configuration properties of the Select tool (other tools as well).
The purpose of this field is that it allows new fields to come in, in cases when your input file may change. You have the ability to determine where new fields will be placed in the file by moving this field's position.
There are several different add-on options to the basic bundle of Alteryx that a user can purchase. Based on the license installed on your system, only the corresponding tools will be available. Tools that are not licensed still show up, but are in fact locked. A workflow will fail to run when it comes to a locked tool.
If a tool is appearing to be locked, and you feel this is in error, contact Fulfillment. Someone will contact you promptly and walk you through your setup to make sure your serial number matches your installed license so you can have the full functionality you have subscribed to.
To inquire about the different add-on options to the basic bundle or to upgrade your configuration, contact your sales representative.
The minimum and recommended system requirements are referenced on https://www.alteryx.com/. Ideal system configurations depend on the type of analysis you are conducting. Some processes are much more memory intensive and depend on other factors including file location, file size, other programs that are running simultaneously, etc.
You need to specify a file prefix. From the Configuration Properties there is a box to the right of Output Format called File Prefix. While this box is optional, you MUST create a prefix if there are multiple Allocate reports in the workflow. Otherwise each report will overwrite each other as it is created downstream.
See Allocate Report Tool.
In the workflow window, where the workflows are built, notice the tabs across the top. These allow you to see the workflows you currently have open and allow you to toggle from one workflow to the next. Right click on a tab for additional display options. You can tile multiple workflows to compare side by side.
Expressions can be saved so that they can be used over and over again without having to create them from scratch.
Create your expression using a combination of selecting variables and inserting them into functions . Once you are happy with the formulated expression, click Save and specify a name for your expression. Your expression is now saved for future use.
Connect an Output Data tool to the data stream and specify the file type and location. From the Options: specify how many records to be output into a single file. If the specified number is less than the total number of records, multiple files will be outputted. The resulting multiple files will be named sequentially, i.e. file.dbf, file_2.dbf, etc.
Another multi file output option, is to do so according to values of a particular field. From the Configuration Properties of the Output Data Tool, check the box: Take File Name From Field. When this box is checked, a separate file will be written out for each value of a particular field. Additionally you can chose to: Append Suffix or Prefix to File/Table Name, Change a file name or change the entire file path.
Default processing adds quotes when:
1) An empty field value is replaced with "". This is so it can differentiate from NULL.
2) A field value that contains leading or trailing whitespace becomes quoted. Whitespace outside of quotes in a CSV gets ignored by most software.
3) The field contains delimiters.
4) The field contains single or double quotes.
There are 3 options for quoting in a CSV file from the Output Data tool. Choosing Never, will never add quotes to output fields.
Check your configurations upstream. If there is an Allocate Append tool, be sure the spatial object specified in the drop down selection is a polygon object and NOT a point object. If the error is coming from a Reporting Map tool, ensure you are not choosing Smart Tiling on a String field as a Thematic mapping tile mode.
Yes you can. To run a workflow from a DOS prompt simply add the path to the Alteryx executable in your Environmental Variables settings and then create a batch script with the workflow you’d like to run. The batch script would only need the executable name and the workflow name.
A layout file can be created via the Select Tool. Link a select tool up to your data stream and go to Options > Save/Load Field Configuration and specify the file name and file location. A *.yxft (Alteryx Field Type) file will be written out and readable in any text editor.
Another option is to Use the Field Info Tool.
You can overwrite your input file by simply adding one of the following "blocking tools" to your workflow: Block Until Done Tool, Auto Field Tool, Sort Tool, or Unique Tool.
Some program has told the operating system to only let Alteryx use a single processor. To specify which processors Alteryx can use:
- go to the Windows Task Manager
- Click on the Processes tab
- Right-click on the AlteryxGui.exe and select Set Affinity...
- Check the processors that you would like Alteryx to utilize.
Check the data type of the field you are filtering on. Most likely this field is a double. This is not a bug, it is how computers store numbers. The value of 2 stored as a double with 16 decimal places of precision is actually somewhere between 1.9999999999999999 and 2.0000000000000019.
To demonstrate this, use a Formula tool to create a new field and set the field type to string 20 length. Use the Conversion function to convert the value to a string
Ways round this: you can convert the field to an integer or fixed decimal if you intend to compare the values of fields.
Use the CompareDigits or CompareEpsilon Test Functions to compare values of fields.
For more information about Floating Point numbers, see: http://en.wikipedia.org/wiki/Floating_point
Each time the Join tool is configured it remembers the fields that were there each configuration. If the fields are not currently there, they are still remembered by the tool and appear in red. From theOptions button, select Forget Missing Fields.The red fields will be dropped.
- Any tool with an embedded Select Tool will have this same functionality: Append Fields Tool, Join Tool, Join Multiple Tool, Find Nearest Tool and Spatial Match Tool.
Most likely, different cells have different data formats associated with them. When bringing in XLS or XLSX input, be sure of the following:
From the Input Data Tool options number 2 File Format, choose Microsoft Excel (*.xlsx). See Alteryx driver for Excel (.xlsx).
If using the other Microsoft Excel Legacy XLSX option, this occurrence is due to a well-documented limitation of the Microsoft Jet Engine which is what Alteryx uses to read Microsoft files. By default, Microsoft reads through the first 8 rows of data to determine the field type of a column. It then passes this information to Alteryx and that is what we use to read the file.
- From the Input Data Tool configuration, First row contains data. This will force all fields as V_String.
- Configure the Dynamic Rename Tool to "Take Field Names from First Row of Data."
- Use the Auto Field Tool to properly assign the best field type for each data column.
The user has the choice to work around this issue or fix it in their registry. The workaround includes the following:
The fix for this involves changing a setting in your registry. These instructions are being provided as well as document from Microsoft, as Alteryx cannot be sure that changing this setting will not cause problems with other applications. For more information on this issue: http://support.microsoft.com/kb/189897.
To change the Registry setting:
- Go to Start > Run and type "regedit"
- In the registry go to HKey Local Machine > Software > Microsoft > Jet > 4.0 >Engines > Excel
- Double Click: TypeGuessRows
- Change the value to 0 (zero)
For performance reasons, setting the TypeGuessRows value to zero (0) is not recommended if your Excel table is very large. When this value is set to zero, Microsoft Excel will scan all records in your table to determine the type of data in each column.
The difference is that a table with a $ references a worksheet contained in the Excel file whereas a table without a $ references a range of cells to import. In most cases the range incorporates all cells so there is no difference when bringing in the file.
As a best practice, the recommendation is bringing in tables with a $ in order to ensure you are referencing the entire worksheet because if records are added and or incorporated in the range, you will miss some records.
For more information:
The %temp% string will reference the system temp directory of the machine Alteryx is running on. The %temp% is not an environment variable. It may look similar, but it cannot be expected to behave the same as the environment variable of the same name.
The tools that require data installs are now installed by those data installs. You will need to install the latest datasets to get additional content. Visit Community with your technical and product support questions or if you need a new shipment of data installation media.
This impacts the following Macros: US Geocoder Tool, Canada Geocoder Tool, Non Overlapping Drivetime Tool, Profile Comparison Report Tool, Profile Detail Report Tool, and Profile Rank Report Tool.
The following blog article provides the most common manipulations and how you might approach them using Alteryx:
The following blog article provides details on the different types of joins: