Hi,
I sometimes want to speed up load times for a Calgary Input tool and I do this by using a local copy of the Calgary database in question.
To make it easier to switch between the local copy and the original on the network, I would like to use a user constant. If I use a constant, such as %User.mypath%, in the configuration of the Calgary input tool, the interface returns an error saying that it can't find the database at the given path. The path indicated in red by the interface is a combination of the workflow directory, the string "%User.mypath%" and the name of the Calgary database file, i.e. "c:\Users\xxxxxxx\Work\Alteryx\%User.mypath%\Traincounts.cydb". However, the correct path is "c:\Users\xxxxxxx\Work\TraincountsDB\Traincounts.cydb", where "c:\Users\xxxxxxx\Work\TraincountsDB" is the user constant.
The workflow itself works fine and the Calgary Input tool finds the correct database, but I can't access the field and query part of the Calgary Input configuration interface. How can I use a user constant in the Calgary Input configuration and still be able to use the field and query part of this tool?
Kind regards,
Stefan
