Pass dynamic parameters in sql script

Vikas038

Hi Team,

My requirement is to pass dynamic parameters through within sql script similar to SSRS reports.

Steps that i will follow in Alteryx.

1. Pass Sql script via input data option. My script will be like below:-

*********************Sample Script**********************************

select * from view_mdc_ma_research
where dateofconsumption>=date'@Startdate' and dateofconsumption<=date'@Enddate'

***********************************End**********************************

2. please suggest me that how can i make users capable to pass dynamic dates to replace @Startdateand @Enddate. 

3. I have to place an application based on this requirement on Gallery

I have to deploy some urgent reports to showcase further. Please share sample workflow as well for workable solutions.

afv2688

Hello @Vikas038 ,

I would use interface tool to update the query like this.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

update sql.yxmc