UPDATES FOR GET and TRANSFORM IN EXCEL 2016 AND THE POWER QUERY ADD-IN

www.office.com/setup

Exceed expectations 2016 incorporates an intense arrangement of elements in light of the Power Query innovation, which gives quick, simple information assembling and forming abilities and can be gotten to through the Get and Transform segment on the Data lace.

We are satisfied to declare five new information change and network includes that have been asked for by numerous clients.

These updates are accessible as a feature of an Office 365 memberships. In the event that you are an Office 365 endorser, discover how to get these most recent updates. In the event that you have Excel 2010 or Excel 2013, you can likewise exploit these updates by downloading the most recent Power Query for Excel include.

These updates incorporate the accompanying new or enhanced information availability and change highlights:

Support for a similar document expansions in Text and CSV connectors.

ODBC and OLE DB connectors—bolster for Select Related Tables.

Improved Folder connector—bolster for “Join” from the Data Preview exchange.

New Change Type Using Locale alternative in Column Type drop-down menu inside Query Editor.

New embed venture after alternative in steps sheet inside question proofreader.

 

SUPPORT FOR THE SAME FILE EXTENSIONS IN TEXT AND CSV CONNECTORS

With this refresh, we overhauled the rundown of upheld document expansions in From Text and From CSV connectors. Presently, you can peruse and select any content (*.txt), comma-isolated esteem (*.csv) or organized content space delimited (*.prn) record as the initial step of the import stream for both connectors. Then again, you can change to the All documents (*.*) channel alternative and select to import information from whatever other unlisted record.

 

ODBC AND OLE DB CONNECTORS—SUPPORT FOR SELECT RELATED TABLES

When utilizing the ODBC and OLE DB connectors, we empowered the Select Related Tables catch in the Navigator exchange. This choice—effectively accessible for other social information sources—enables clients to effortlessly choose tables that are straightforwardly identified with the arrangement of officially chose tables in the Navigator discourse.

 

Improved FOLDER CONNECTOR—SUPPORT FOR COMBINE BINARIES FROM THE DATA PREVIEW DIALOG

In the January 2017 refresh, we transported an arrangement of improvements to the Combine Binaries encounter. You can take in more about those improvements in this article.

This month, we made it less demanding for clients to get to the Combine Binaries highlight by enabling them to join various documents specifically from the organizer Data Preview discourse inside the Get Data stream, without going into the Query Editor.

www.office.com/setup

Note that uncovered various alternatives (Combine and Combine and Load) enable clients to additionally refine their information before stacking it into the worksheet or Data Model.

 

NEW CHANGE TYPE USING LOCALE OPTION IN COLUMN TYPE DROP-DOWN MENU INSIDE QUERY EDITOR

In the Query Editor, it is conceivable to see and alter segment sorts by utilizing the Column Type drop-down menu in the see region.

With this discharge, we included the Change Type Using Locale choice to this drop-down menu (already accessible by right-tapping the segment header and afterward choosing Change Type > Using Locale). This choice enables you to indicate the coveted segment sort and area to use for the change, which influences how content esteems are perceived and changed over to other information sorts, for example, dates, numbers, and so forth.

 

NEW INSERT STEP AFTER OPTION IN THE STEPS PANE INSIDE QUERY EDITOR

With this refresh, we included another setting menu choice in the Query Editor window to effortlessly embed new strides in existing inquiries. The Insert Step After alternative gives clients a chance to embed another custom stride directly after the present chosen step, which can be the last stride or any past stride inside the question.

Leave a Reply

Your email address will not be published. Required fields are marked *