Need to pass Tablename as Parameter in SQL in Dynamic Input

Question

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?

patrick_digan · Accepted Answer

@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.

rafalolbert · Accepted Answer

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?