Under the create new query screen, using the profile dropdown select an existing connection profile Excel, this will be presented with two options 1) Connect to existing 2) Connect to new - as follows.
- Choose the remote file option to provide the share location of the excel file along with username/password.
- Click on the Save button to navigate to query builder, you can either use custom SQL query or RightQuery option to create a query on the excel data. Drag and drop the file name to the SQL editor, execute the query and save the query for reusability.
- When the excel sheet contains rows to be excluded as part of the querying, add the cell range followed to sheet name as follows:
- If the sheet name is "Sales Analysis" and the range to be selected is starting from A28 to I10000, the SQL should be written as follows: