Alteryx Designer Desktop Knowledge Base

Set yourself up for success with excerpts from the 2017 Tips and Tricks Book for bringing data into your workflows!

Set yourself up for success with excerpts from the 2017 Tips and Tricks Book for workflow design!

In Alteryx Designer 2019.1, after adding Browse tools to all of the output anchors of a tool using Right-click > Add All Browses OR Ctrl + Shift + B, running the workflow returns an Unhandled Exception error. The workflow runs indefinitely until Designer is canceled from Windows Task Manager.

a guide to effectively use Salesforce Tools

User receives error when outputting hyper file: Failed to start a new Hyper instance. Context: 0x86a93465 Caused by: The Hyper server process exited during startup with exit code: 1, Command-line: ""C:\Program Files\Alteryx\bin\Tableau\bin\hyper\hyperdstarter.exe" -x "database_directory=C:\Users\SVRC0049\AppData\Local\Temp"

A description of how the Local Staging functionality within the Snowflake Bulk Loader works

Tired of connecting tools one-by-one? This can definitely become inconvenient when you want to join/union many inputs or if you want to run a slew of analyses...

If you are building a predictive model, inevitably you will want to analyze the effect that your independent variables have on your dependent variable. This article is meant to shed some light on the Alteryx-specific options for this type of analysis!

The “D” notation is common to Fortran implementations and generally represents double precision numbers. This notation is much less common than the E notation, but Alteryx does recognize it.

In Alteryx, the + (plus) symbol has different functionalities depending on if you are using text (string) or numeric fields.

The Report Map Tool (master it here) allows to create thematic maps by selecting a "Theme" field on the Data tab and then further defining the theme on the Layers tab

Hive ODBC can be slow when writing to tables. If you are looking for a faster option to write to Hive and want to create a new table or overwrite an existing table, use the IN-DB tools to output your data. 

The Table Tool has many options for formatting data - e.g. prefixes and suffixes can be added, certain fields can be highlighted based on formulas and many more. Don't fret if you want to format more than one column at once - there's a workaround using the "Dynamic or Unknown Fields" option.

Calgary is a list count data retrieval engine designed to perform analyses on large scale databases containing millions of records. One use case for a Calgary database in an App or Macro is to offer users certain predetermined criteria (e.g. geography) to select and then return the corresponding data to them. A back-end process can combine multiple data sources, format and pre-filter as needed, and load them into a Calgary database that can be queried quickly by the app or macro. This way, the bulk of the processing happens outside of the app or macro allowing data to be returned more quickly. 

how to merge cells with the table tool

The Visual Query Builder window can take a long time to load because it always loads all column metadata for all tables for all schemas, even if a default database is selected in the database connection. This article will walk through using the In-Database tools as an alternative to using the Visual Query Builder.

A Calgary Database is a proprietary Alteryx format that allows users to query against a file of millions of records quickly without having to read in all the data.

Snowflake did an upgrade which results in an error message for both the data input and data stream out tools: Result download worker error: Worker error: [Snowflake][Snowflake] (4) REST request for URL #URL failed: CURLerror (curl_easy_perform() failed) - code=91 msg='SSL server certificate status verification FAILED'.

User encounters an error due to invalid character in table name: Data Stream In (6)    Executing PreSQL: "CREATE TABLE table-name¶ROW FORMAT SERDE¶'org.apache.hadoop.hive.serde2.avro.AvroSerDe'¶STORED AS INPUTFORMAT¶'org.apache.had..." : [Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error running query: org.apache.spark.sql.catalyst.parser.ParseException: ¶mismatched input '-' expecting (line 1, pos 18)¶¶== SQL ==¶CREATE TABLE table-name¶------------------^^^¶ROW FORMAT SERDE¶'org.apache.hadoop.hive.serde2.avro.AvroSerDe'¶STORED AS INPUTFORMAT¶'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'¶OUTPUTFORMAT¶'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'¶TBLPROPERTIES (¶'avro.schema.literal'= '{ "type": "record", "name": "Alteryx", "fields": [{ "type": ["null", "string"], "name": "field1"},{ "type": ["null", "string"], "name": "field2"},{ "type": ["null", "string"], "name": "field3"}]

Calgary Loader (2) PagedFile::Add: keys out of order, sort not supported yet.

User is getting an error writing an excel file to a shared drive.