Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Selecting Columns on Excel Data Import

8 - Asteroid

And...I figured it out. Name the range in Excel, then save the file. Once you do that, the "Select a named range" radio button will be available. It does mean that all of your columns need to be in a contiguous range though. (Or I suppose you could have multiple inputs that you then join)

Highlighted
5 - Atom

I had the same problem where I could not edit the SQL directly when .xlsx was selected (in 2019.4).

 

As a workaround, you can change the File Format to be .sqlite, then click the Table or Query "...", edit the SQL, then set the File Format back to .xlsx.

Labels