Alteryx Designer Desktop Knowledge Base

A quick reference guide that will help you prepare two different data sources for use with Fuzzy Match Merge Mode

Upon creating a BINGO game, I came across a technique that I thought could be useful in "real world" scenarios for users who are attempting to iterate a process and then replenishing the data after a certain amount of time.

Binary (bit level or bitwise) operations operate on one or more bit patterns or binary numerals at the level of their discrete bits. They are typically used to manipulate values for comparisons and calculations - and encryption!

When running a workflow that uses a RegEx tool ahead of a Select Record tool, you receive different results with or without uding the Use AMP Engine.

Troubleshooting the Error: The field “[field_name]” is missing. Compare the tool configuration with the input stream.

Troubleshooting the error: No valid fields were selected.

Troubleshooting the Error: At least one Unique Field must be selected.

Troubleshooting the Parse Error at char (n): Unknown variable "[variable_name]" Expression (#n)

How to remove unnecessary rows in Excel

How to capture values not recognized as dates with

Error while connecting to a database, from the Input Data Tool - Error: Input Data (13): Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.

Troubleshooting Parse Error at char(n): Invalid type in operator [== < > + -]

Troubleshooting the error: The formula "[formula_name]" resulted in a string but the field is numeric. Use ToNumber(...) if this is correct.

Troubleshooting the "Unknown Function YEAR()" error, or other related Date expressions.

Issue   Saving or running the workflow in the Designer causes the following error to occur:   An Unhandled Exception occurred. A previous action may not have completed successfully. Click OK to send the development team the error log so that we can fix this error in a subsequent release.   Environment   Alteryx Designer   Diagnosis    Checking the logs from %PROGAMFILES%\Alteryx\ErrorLogs\AlteryxGUI shows the following error:   Alteryx Designer x64 - 2019.2.5.62427 Type: System.ArgumentException Message: Cannot have ']]>' inside an XML CDATA block. Source: System.Xml OS Version: Microsoft Windows NT 6.2.9200.0 OS Is x64 Capable: True Selected Plugin: LockInGui.LockInSelect.LockInSelect Processor: Intel(R) Xeon(R) CPU E5-2676 v3 @ 2.40GHz Private Memory: 380923904 -------------------------------------------- at System.Xml.XmlTextWriter.WriteCData(String text) at System.Xml.XmlElement.WriteElementTo(XmlWriter writer, XmlElement e) at System.Xml.XmlElement.WriteContentTo(XmlWriter w)   Cause   The use of "]]>" in the following tools (not an exhaustive list) causes the error: Formula tool Filter tool Report text tool R tool Python tool   Solution   Avoid using "]]>" in the tool or escape the ">" to "&gt;".

  Be sure to first understand that different people/organizations all have different definitions on what they mean by rounding.  Once you are clear on what you need, you can use Alteryx to round your numbers.   Example 1: Divided by the place you want to round to, use CEIL to round up, then multiply back by the place:   324 to 400 CEIL([Number] / 100) * 100   Example 2: Ceiling and floor just go to the nearest integer.  The ROUND(x, multiple) function will allow you to specify the level of precision on which to round, very similar to Excel.  But you can't specify the direction, so in your example, if your did ROUND(3425.123,1000) it would return 3000.   Example 3:  Please see the attached v10.0 workflow which is more dynamic. The text input identifies the mapping for the conversion joined with length of source input - then an expression is applied in the Formula Tool.         The final output.      More on rounding.

One trick I often use to conditionally update a field is the Boolean IIF function.  IIF is basically a shorthand version of a single condition test.