Hello! I have a common process that I run on multiple tables within a database and want to build an analytics app that would allow my users to change the table name as needed.
I have built a process that uses actions with an update string, but the process won't run because Alteryx is trying to validate my query and it is pointing to a table that doesn't exist.
My query looks something like:
Select * from 'parameter1'_'parameter2'_data
Writing this, I realize that I could point it to a table that does exist and overwrite the strings for that table, but if that table would ever get dropped my process would stop working and I would like to avoid that if possible.
Thoughts?
Update: Pointing to a table that already exists doesn't work since it is not technically a string the replace doesn't replace and making the parameters strings causes the same failure.
