Can somebody tell me where is "Choose table or specific Query" ?

Hello guys.

In the input section, when i click to the 3rd option on the left (table or query), It should give me (Choose table or specific Query) but i gave (Select Excel Input). I need to use the SQL editor . I am using the latest version of Alteryx (i just installed 3 days ago)

my screentutorial ?!

Input

Accepted answers

patrick_digan

@Longdaica The old SQL editor is gone but it's still possible to write SQL if you edit the XML. First, you will need to go to options >>> User Settings >>> Advanced and then check the box "Display XML in Properties Window". Then you can go to your input tool with the excel file, click on the Xml icon on the left, and then "Edit" on the top right:

Here you can write a SQL statement like before:

<File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="25">File.xlsx||| Select * From `Selections$A1:C5`</File>

You won't want to change anything between the < > above (green text). You would just be changing the File and SQL (red text). You would click ok when you're done. Then it will look like this:

It's certainly not ideal, but I still use it.

All comments

Longdaica

please help

BenMoss

According to the help it appears this ability has been removed as an option when bringing in an excel file: https://help.alteryx.com/2018.1/DbFileInput.htm

We would need someone from Alteryx to confirm but the documentation definitely suggests this.

What exactly were you looking to achieve with your SQL statement? I assume it can be done very easily inside Alteryx anyway.

Ben

patrick_digan

Here you can write a SQL statement like before:

<File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="25">File.xlsx||| Select * From `Selections$A1:C5`</File>

You won't want to change anything between the < > above (green text). You would just be changing the File and SQL (red text). You would click ok when you're done. Then it will look like this:

It's certainly not ideal, but I still use it.

unknown

Thanks Patrick!!

https://community.alteryx.com/t5/user/viewprofilepage/user-id/2387

OliverW

Thanks @patrick_digan for the idea with the XML editing.

You can actually even do it a little easier in 2018.1, you can just add it here:

Untitled.jpg

evilla

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703