Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: May 2017 updates for Get & Transform Excel 2016 & Power Query add-in

18 May 2017   #1
Brink

64-bit Windows 10 Pro
 
 
May 2017 updates for Get & Transform Excel 2016 & Power Query add-in

Quote:
Excel 2016 includes a powerful set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.

Today, we are pleased to announce three new data transformation and connectivity features that have been requested by many customers.

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

These updates include the following new or improved data connectivity and transformation features:
  • Split Column by Delimiter—automatic detection of delimiter character
  • Combine Files—ability to select sample file to use
  • DB2 Connector—option to specify Package Collection
Split Column by Delimiter—automatic detection of delimiter character

When splitting column by delimiter inside Query Editor via Home > Split Column, Excel will automatically detect and populate the Delimiter field in this dialog, based on text pattern detection in the data preview rows. Note that you can still change the delimiter if needed, but this automatic detection saves a few clicks in many cases.



Combine Files—ability to select sample file to use

This month, we continue making incremental enhancements to the Combine Files experience. One of the common areas of recent feedback has been to add the ability to select a file from a folder to use as the sample file to select objects and specify any custom transformation steps (if needed).

With this release, we added a new control in the file preview dialog to allow you to choose a file available in the selected folder. The default selection is the first file found—however, this can now be easily customized by users.



DB2 connector—option to specify Package Collection

The DB2 connector window now includes an option to specify the package collection to connect to within a given DB2 server. This new option, available under the Advanced Options section in the DB2 connector dialog, can only be used with the Microsoft IBM DB2 driver.



Learn more
—The Excel team


Source: May 2017 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs


My System SpecsSystem Spec
.
Reply

 May 2017 updates for Get & Transform Excel 2016 & Power Query add-in




Thread Tools




Similar help and support threads
Thread Forum
Excel 2016
Hi I have been trying to find out what Im doing wrong with this. Its not .pgn data im wanting its just copy info with noation I am wanting to create an Excel 2016 searchable database for ECO Chess openings. I have tried Data>Get data > webpage. I have attached a couple of screen shots to try...
Microsoft Office
April 2017 updates for Get & Transform in Excel 2016 and Power Query
Source: April 2017 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs
News
Announcing Insider build 16.0.6741.2017 for Office 2016
Source: Announcing Insider build 16.0.6741.2017 for Office 2016 on Windows - Microsoft Community How to Check for Updates in Office 2016 for Windows
News
New feature updates for Power Pivot in Excel 2016
Source: New feature updates for Power Pivot in Excel 2016 - Office Blogs
News
Power Query for Excel January update
Source: Power Query January updateâ
News


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 05:56.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App