Power Query Cookbook: Use effective and powerful queries in Power BI Desktop and Dataflows to prepare and transform your data by Andrea Janicijevic

Author:Andrea Janicijevic [Janicijevic, Andrea]
Language: eng
Format: azw3, pdf
Publisher: Packt Publishing
Published: 2021-10-15T00:00:00+00:00

You will end up with a query named Append1 (you can rename this as you wish), with appended data from the two queries. In this case, some column headers do not match between the two tables, such as CustomerKey from FactInternetSales and ResellerKey from FactResellerSales. In this case, the Append1 query will show null values:

Figure 5.27 – Null values for non-matching columns

You can append more than two tables and apply the same logic to a wider number of queries.

Combining multiple files

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.