community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

SQL editor

Highlighted
Meteor

Hello everybody

 

Can somebody tell me why i am having this error all the time ?

I am trying to use SQL command to filter data before applying anything else!!!

3.pngerror

Alteryx Certified Partner
Hey

Have you tried using the excel legacy driver?

Neil
Meteor

can you please explain ? Sorry i am a beginner

Alteryx Certified Partner

Hey @Longdaica

 

Certainly...in the file format drop down, you should have an option called "Microsoft Excel Legacy" (if you don't install this driver: https://www.microsoft.com/en-us/download/details.aspx?id=13255)

 

This will allow you to use the SQL functions on your spreadsheet:

 

Legacyxlsx.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Meteor

Very nice of you.

 

Btw Can I call 2 files in a single command ?

 

 

For example: 

 

Select file2.field 3 from file1 A, file2 B

where A.field 1 =B.field2 and A.field > 1000?

Alteryx Certified Partner

Hey @Longdaica,

 

I couldn't get it to work using a separate file, but it works with multiple tabs within the workbook.

 

LegacySQL.PNG

Labels