Text box to Input data to SQL

Hi!

I am trying to feed an user ID in the Input Tool via a text box.

The input tool is supposed to run a simple SQL query: Select * From CC_USAGE Where end_user_Id = 'xxx'

xxx should be replaced with the Used ID entered in the text box, in a format like 123456

When I run the app, I can see that xxx is replaced but still I do not have any outcome result.

Thanks a lot!

SQL report.yxmd

Input

Accepted answers

Given your limited workflow, you would also need to make a change to the Interface Designer properties to include the "browse tool" in your output. When an App is running all browses are disabled unless you explicitly call the out for viewing.

All comments

You're doing everything right. The only thing that I can think of is the actual SQL - have you tested this outside of Alteryx? Could it be that the user ID is a number rather than a string? In which case you'll need to get rid of the single quotes.

Thanks

Michal

@MichalM unfortunately, I have already tried that and it doesn't work. So I'd say that the ID is a string.

Besides, if I populate the SQL query in the Input tool with an ID, it works fine. But as soon as I try to use the text tab I get that error.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703