Input Data tool - SQL query

Hi,

I am trying to utilize the sql query function of the input data tool. When I go to double click inside the box to write my query nothing happens. Is this a bug?

Input

Accepted answers

Paulteryx

Hi,

I did some more looking in to it and Alteryx doesn't support SQL via the input tool for Excel as of 2018. Fortunately, this is a topic that has already been discussed here and you can see the workaround highlighted in this post.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Can-somebody-tell-me-where-is-quot-Choose-table-or-specific/m-p/150761/highlight/true#M23463

Cheers

All comments

Paulteryx

Hi Ryan,

Just out of curiosity, what Driver are you using, and to what database are you connecting?

Cheers

RyanScott

Hi Paul

I'm loading in excel files *.xlsx

I'm sorry, I'm not sure what you mean by driver.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703