How to make SQL query fields Dynamic

[CharviJain]

Hi All,

I am looking for a solution to make SQL query dynamic,  connected to Hive in such a way that all the fields (columns) added to Query can be made dynamic (to be chosen) before running the query in Alteryx workflow.

[CharviJain]

Hi All,

I am looking for a solution to make SQL query dynamic,  connected to Hive in such a way that all the fields (columns) added to Query can be made dynamic (to be chosen) before running the query in Alteryx workflow.

[ArnaldoSandoval]

Hi @CharviJain 

Perhaps Nathan's video may help you Alteryx - Dynamically Pass a Value to SQL Stored Procedure or Data School's Dynamic SQL Queries in Alteryx 

hth

Arnaldo