A great and vast set of features (called as an Excel add-in) based on the Microsoft Power Query technology are made available in Excel 2016 to make it capable for quick as well as trouble-free gathering and shaping of the data, resulting in enhancing the self-service Business Intelligence experience in Excel and this can be obtained easily from the Get & Transform section provided on the Data ribbon.
On the demand of many of the users, we had brought three new features working for data connectivity and transformation.
Microsoft Office 365 subscribers can search for the guidance to achieve these latest updates as these are made available as an Office 365 subscription’s part. Excel 2010 or Excel 2013 users can also download the amazing Power Query tool for Excel add-in and enjoy the benefits given by these updates.
Office 365 (the brand name used by Microsoft for a group of software and services subscriptions, providing productivity software and related services to subscribers) subscription lets to attain the latest applications for the same previously paid price and additionally at the same time of the release.
The three latest and enhanced data transformation and connectivity features included in these updates are as follows:
- Combine Files: Ability to select sample file to use
- DB2 Connector—option to specify Package Collection
- Split Column using Delimiter along with automatic detection of delimiter
Talking something more about these features:
Combine Files: Ability to select a file to use as a sample
Based on the recent feedback seems common to most areas; a feature providing an ability to choose a file as a demo file from a particular folder, to further choose objects and identify any step related to custom transformation along with many other improvements to the Combine Files experience are given in this month. Also, a new control to permit you the selection of a file available in the selected folder was added in preview dialog box of file. Though by default, the first file that appears has been selected yet the users can customize this according to them easily.
Split Column using Delimiter along with its automatic detection
Delimiter is used to separate columns or fields within the file. Here, on the basis of text pattern recognition in the data preview rows, excel will detect the Delimiter in this dialog box automatically at the time of splitting column using delimiter within the Query Editor passing through Home tab followed by Split column option. This automatic detection is good as in most of the cases it allows only a few clicks but in case you want to change the delimiter, you can do it easily.
DB2 connector incorporates an option to specify Package Collection
As written in the heading, the DB2 connector window incorporates a latest option to identify the package collection to link to an inbuilt provided DB2 server, in the DB2 connector dialog box beneath the Advanced Options section but its usage is limited with the Microsoft IBM DB2 driver only.