Using the 1010data Excel Add-in, we can run a query on 1010data from Excel and have the results directly downloaded into an Excel worksheet.
<note type="base">Applied to table: retaildemo.salesdetail</note> <sel value="between(date;20110101;20110331)"/> <link table2="retaildemo.products" col="sku" col2="sku" suffix="_prod" type="select"> <sel value="(dept=19)"/> </link> <tabu label="Tabulation on Sales Detail" breaks="groupdesc_prod"> <tcol source="xsales" fun="sum" name="tot_sales" label="Sum of`Extended Sales"/> </tabu> <sort col="tot_sales" dir="down"/>
In Microsoft Excel, from the _1010q Sheet, which is where we will specify the query we want to run on 1010data.menu, click . This will open a q-sheet in a new tab labeled
Copy the Macro Language code for the 1010data query and paste it into the section of the q-sheet labeled 1010data Macro Code.
Our q-sheet should look similar to the following:
Enter your 1010data credentials and click Secure Login.
As the query runs on 1010data, you'll see a 1010data Query Progress dialog, which shows the percentage of total operations completed within the current query. When the query finishes running, you should see a dialog saying: Query completed successfully. Click OK to dismiss this dialog.
To see the results, click the Sheet1 tab:
You can see that the results of this query have been downloaded into Excel and are the same as what we got when we ran this query directly on 1010data.