MySQL DB_Name

[Homelander]

Hi,

I have been recently forced to reinstall Alteryx and MySQL ODBC Driver on a virtual machine. The issue I am encountering now is that while previously I was able to query the MySQL DB with just table_name.column_name , now I have to fill in DB_Name.table_name.column_name. While I can change the queries in all of the workflows (>10 workflows), I was wondering if there is a quick workaround.

I am using a Unicode driver for the ODBC connection to MySQL.

Has anyone encountered this issue and how did you solve this?

Thanks for your help!

[echuong1]

A workflow is actually just an XML, so it is possible to do a "find and replace" within your workflow XML. In your case, you can look for any instance of the table_name and replace it with the DB_name.table_name.

This article may be helpful when trying to scan through your workflows:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/FINDER-3-0-Search-all-your-workflows-c...