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 @Startdate and @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 · Accepted solution]

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

[Vikas038]

Thanks, Team.

It is working for me.