Table of Contents What is Merge Query ? Merge query is a feature of power query which helps us to get data from multiple files based on one or multiple common columns. Merge query works in similar fashion as VLOOKUP in excel but we can do a lot more using this feature. VLOOKUP in excel means Vertical lookup….
Table of Contents Example “Code” column is missing in table 1. “Country” and “Parts” are common columns in both the tables. Some of the countries and parts do not have code in Table 2 (India-Item1, UAE-Item2) Some of the countries and parts have code in Table 2 but do not have quantity in Table 1…
Table of Contents Example “Code” column is missing in table 1. “Country” and “Parts” are common columns in both the tables. Some of the countries and parts do not have code in Table 2 (India-Item1, UAE-Item2) Some of the countries and parts have code in Table 2 but do not have quantity in Table 1…
Table of Contents Example “Code” column is missing in table 1. “Country” and “Parts” are common columns in both the tables. Some of the countries and parts do not have code in Table 2 (India-Item1, UAE-Item2) Some of the countries and parts have code in Table 2 but do not have quantity in Table 1…
Table of Contents Example “Code” column is missing in table 1. “Country” and “Parts” are common columns in both the tables. Some of the countries and parts do not have code in Table 2 (India-Item1, UAE-Item2) Some of the countries and parts have code in Table 2 but do not have quantity in Table 1…