This makes it easier to provide input values as well as input IDs. The new popup dialog for single or multi-selection input controls lets you easily view the ID and Caption for each parameter value, as well as search within the list of values by any of these two fields. You can filter the list of parameters to "only required parameters". SAP HANA Connector – Enhancements to Parameter Input UX: The Parameter Input UX for SAP HANA connector has been improved. Search the list of columns and select the column you want to scroll into preview and select. "Go to Column" in Query Editor: Quickly find columns in the Query Editor by choosing Home > Go to Column in the Query Editor ribbon. Switch between Basic and Advanced modes by selecting either option at the top of the dialog. New transformation – Basic mode for Group By operation: In the Group By transform dialog, use the new Basic mode to group by a single column, and define a single output column. Find this new option in the Advanced Options section of either dialog. New transformation – Split Column (by delimiter/number of characters) into rows: A new option in the Split Column by Delimiter and Split Column by Number of Characters transformation dialogs allows you to specify whether to split into new columns (previous default behavior) or split into new rows.
This means you don't have to have expertise in algorithms or complex logic for transforming or extracting data from other columns, or how to define those transformations in the Query Editor. Based on these examples, Excel will automatically detect and apply the required transformations. New transformation – Add Column by Example: In the Query Editor, create a new column by specifying a set of examples of the desired output. Updates for Get & Transform and the Power Query add-in
0 kommentar(er)
