Microsoft announces new features for Get & Transform in Excel 2016.Excel 2016 comes with a set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. Get & Transform allows users to connect, combine, and refine data sources to meet their analysis needs.
These updates include the next features:
- Support for the same file extensions in Text and CSV connectors.
- ODBC and OLE DB connectors—support for Select Related Tables.
- Enhanced Folder connector—support for “Combine” from the Data Preview dialog.
- New Change Type Using Locale option in Column Type drop-down menu inside Query Editor.
- New Insert Step After option in Steps pane inside Query Editor.
Support for the same file extensions in Text and CSV connectors
With this update, we revised the list of supported file extensions in From Text and From CSV connectors. Now, you can browse and select any text (*.txt), comma-separated value (*.csv) or formatted text space delimited (*.prn) file as the first step of the import flow for both connectors. Alternatively, you can switch to the All files (*.*) filter option and select to import data from any other unlisted file.
When using the ODBC and OLE DB connectors, we enabled the Select Related Tables button in the Navigator dialog. This option—already available for other relational data sources—allows users to easily select tables that are directly related to the set of already selected tables in the Navigator dialog.
In the Query Editor, it is possible to see and modify column types by using the Column Type drop-down menu in the preview area.
With this release, we added the Change Type Using Locale option to this drop-down menu (previously available by right-clicking the column header and then selecting Change Type > Using Locale). This option allows you to specify the desired column type and locale to use for the conversion, which affects how text values are recognized and converted to other data types, such as dates, numbers, etc.
With this update, we added a new context menu option in the Query Editor window to easily insert new steps in existing queries. The Insert Step After option lets users insert a new custom step right after the currently selected step, which can be the final step or any previous step within the query.