Map query fields to Excel
- Click the Mapper tab, or click the Map tab on the ribbon. You can use the keyboard shortcuts CTRL Z (undo a command) and CTRL F (find a word or words).
- Do one of the following:
- Select a field row in the Mapper and drag it to a column in the Data Set panel. Repeat for each row in the Mapper.
- Select multiple field rows in the Mapper and drag them to a column in the Data Set panel. Studio maps all the selected rows.
- On the ribbon, click Auto Map. The location of the Log column will depend on the Studio v12 Excel settings.
The next step is to run the query.