Dynamic input

[Hamder83]

Hi 

I have a simple flow where I wanna update my sql based on a input selection:

But it does not work.

How to I format the sub_carrier_id so the query works? 

The sql where statement is like this:

where b.consignee_number = '1000004192'
and bl.sub_carrier_id in ('1000000008')
and blsl.scan_date >= '2020-09-01'
and blsl.scan_date < '2020-10-01'
and bl.destroyed_at < '2015-01-01'

[morr-co · Accepted solution]

Hi @Hamder83 :

I believe the issue is how you have sub_carrier_id formatted. When you modify an IN statement Alteryx knows to concatenate the values so you would want to pass a list of values rather than concatenating the list yourself. Your input should look like the image below.

Another option is to leave the values as you currently have them but use the "Replace a Specific String" option.