Update SQL query as per User's selection via interface tool(s)

RajatK

Hi,

I need some urgent help on this. Would be grateful for any/all responses!

Currently working on this requirement where the SQL query (used to extract data) contains a WHERE clause wherein the ledger is filtered out.

If a single selection is to be made, for example primary ledger. The SQL script would be : " where ledger_name= 'PRIMARY' ". But, if a dual selection is to be made i.e., PRIMARY and SECONDARY the SQL script would be: " where ledger_name in ('PRIMARY', 'SECONDARY').

The challenge is I need to have 3 selections as part of the drop down: Primary, secondary and both. 

How could I achieve - When user selects "both" how would it update the query as ledger_name in ('PRIMARY', 'SECONDARY') and when user makes a selection of just PRIMARY it updates as " where ledger_name= 'PRIMARY' "? Please help!

Thanks!

martinding

Hi @RajatK,

You can write your List Values as Name:Value pairs.

Name is what appears to the User.

Value is what is interpreted by Alteryx.

So in your case:

In the Properties Box, write:

PRIMARY:PRIMARY

SECONDARY:SECONDARY

BOTH:PRIMARY, SECONDARY

And now you should be able to use the IN (     ) clause.

The Docs are here:

https://help.alteryx.com/20223/designer/list-box-tool