This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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)
@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: