Fixed decimals values in Alteryx results in Null values and report the following error: Input data (1):not a valid FixedDecimal. FixedDecimal values must be of the form: -nnn.nn
Troubleshooting instructions for the error The system cannot find the file specified when attempting to use a 32-bit database connection in the Input Data or Dynamic Input Tool.\n
Alteryx can connect to databases using different methods. This guide will focus on setting up an OleDB connection to SQL server, however, the same general process can be followed to connect to any database via OleDB.
Even though the Spatial Match tool is extremely fast and efficient, there are additional ways its speed can be further improved. This article provides suggestions to increase performance.
There is a comprehensive list of Data Sources Alteryx Designer / Server can connect to. While only these are supported you still might be able to build your own connector. Additionally a product feature can be requested.
Designer 2020.2 introduces AMP Engine. In many use cases AMP will be faster than the older e1 Engine. However, this article will give some guidance on when to use AMP.
In many cases the IT department might insist on implementing rotating passwords as a security measure. How can this be achieved in Designer and Server for database connections?
In some cases the Python tool will not start. This article discusses the common root cause that during installation there was not enough disk space for all the Python environment files to be created.