Use text box and action tool (update value) to query for several customer numbers.

Hi all,

I want to use the text box tool and the action tool (update value) to input several customer numbers into rows in a text input tool that goes into a dynamic input tool that updates an SQL where query. I can currently only get this to work with a singel customer numbe at a time. How can I make it work with several customer numbers? I am currently using Alteryx Designer 10.7 to create this application.

Developer Tools

Interface Tools

Database Connection

Accepted answers

BenMoss

Hi @PeterPetersen

What I would suggest you do for something like this is keep your text box tool, but request that users create a comma separated list.

You can then use this to update a value in a text input, before using a text to columns tool, in split to rows mode, to parse this list and perform a join against your data.

This is how I have always approached scenarios where I have needed the functionality you desire.

If you need further guidance let me know, perhaps an image of your workflow will allow us to understand how to implement this better.

Ben

All comments

BenMoss

Hi @PeterPetersen

What I would suggest you do for something like this is keep your text box tool, but request that users create a comma separated list.

You can then use this to update a value in a text input, before using a text to columns tool, in split to rows mode, to parse this list and perform a join against your data.

This is how I have always approached scenarios where I have needed the functionality you desire.

If you need further guidance let me know, perhaps an image of your workflow will allow us to understand how to implement this better.

Ben

PeterPetersen

This worked. Thank you Ben!

Spower

@PeterPetersen Would it be possible for you to post this workflow if you still have it?

I am trying to basically do the exact same thing but I am using a list box tool to then update a cell in the text box which then passes through the dynamic input and changes the where clause in the SQL query.

I may have made it more complicated than need be. Any help is much appreciated!

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703