Hello ,
Is there a way to pass tablename through parameter in SQL query in Dynamic input.
I tried passing parameter for other columns it works like this 'COLUMN' and then replacing this value.
But same thing doesnt work with tablename 'TABLENAME' as i think Alteryx try to parse the query and it doesnt recognize the table name
Any thoughts?
Solved! Go to Solution.
@UpendraPandey Can you provide more details or pictures of your setup that isn't working? Alteryx should definitely be able to replace the tablename just like the column.
Hi @UpendraPandey,
All aspects of a SQL query definition can be changed including table name and even the entire SQL end-to-end.
Please use 'Replace a Specific String' and replace old table name with new one, see below for reference:
Thanks,
Rafal
#Excuse me, do you speak Alteryx?