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.
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!!!
can you please explain ? Sorry i am a beginner
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:
Part time Tableau, Part Time Alteryx. Full Time Awesome
Very nice of you.
Btw Can I call 2 files in a single command ?
Select file2.field 3 from file1 A, file2 B
where A.field 1 =B.field2 and A.field > 1000?
I couldn't get it to work using a separate file, but it works with multiple tabs within the workbook.