Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

TCPE-19: Search function in the Results window in Alteryx Designer fails if the Column name(s) contains brackets

AshBill
Alteryx
Alteryx
Created

Environment Details

 

If a column name contains brackets, the search function in the results panel would fail with the following error:

Your results grid interaction could not be completed. Run the workflow and try the interaction again. Click OK to send the development team the error log so that we can fix this error in a subsequent release.
image.png
 
  • Alteryx Designer
    • Version 2021.2 and 2021.3


Cause


One or more column names may have brackets in them.

 

Resolution

 

Solution A

The easiest and simplest way to work around this issue without much change to the workflow is to:

  1. Add a Select tool after the tool used to pull the data from a data source.
  2. Select the column name with brackets.
  3. Rename the column name without the brackets in it.
  4. Save the workflow.
  5. Click run or Ctrl + R.
  6. Try to search again and this time, it would not give you any errors anymore.
image.png

Solution B

Other tools that can be used are:
  1. Filter tool
  2. Formula tool (using Replace)

Solution C

Manual method:

  1. Manually change the column name from the data source.


Additional Resources

No ratings