Merging Data

Question

Hi can anyone help me with merging data&nbsp;I have 2 table which I neeed to merge, but I dont have any relationship to this table&nbsp;the reason why I need to merge is, I want to combined the values from 2 different tables&nbsp;table 1&nbsp;Type &nbsp; AverageA &nbsp; &nbsp; &nbsp; &nbsp; 15B &nbsp; &nbsp; &nbsp; &nbsp; 11C &nbsp; &nbsp; &nbsp; &nbsp; 10D &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp;table 2TypeCategory &nbsp;AvgE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15F &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16G. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9H. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp;so this should results of&nbsp;Category &nbsp; &nbsp;AvgA. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15B. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11C. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10D. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9E. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15F. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 16G. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9H. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp;&nbsp;&nbsp;

pijushroy · Answer

HI&nbsp;tebtim19&nbsp;For example , If you have 4 rows in one table1 and 150 rows in another table2.Append in Power Query&nbsp;and Union in Power BI Desktop will both worksIt is not depends on the ROWS number in both table, The column name should be same when you going to append two or more tables.&nbsp;Go to Power QueryIn table1 and rename the column, "Type" as "Categoty" and "Average" as "AVG"In table2 and rename the column, "TypeCategory" as "Categoty"Go to Append or Append as New and marge the data&nbsp;Hope this notes helps you&nbsp;If solve your requirement, please&nbsp;mark this answer as SOLUTIONIf this comment helps you, please&nbsp;LIKE this comment/Kudos

tackytechtom · Answer

Hio&nbsp;tebtim19&nbsp;,&nbsp;I think you a few options here.&nbsp;&nbsp;One way would be to rename the columns for one of the tables and then use the Append Queries function in Power Query:&nbsp;&nbsp;&nbsp;Another way would be to use the UNION function in DAX:&nbsp;Here the code:NewTable2 = UNION (Table1, Table2)&nbsp;Does this help? 🙂&nbsp;/Tomhttps://www.tackytech.blog/https://www.instagram.com/tackytechtom/&nbsp;

pijushroy · Answer

Hi&nbsp;tebtim19&nbsp;Go to Power QueryIn table1 and rename the column, "Type" as "Categoty" and "Average" as "AVG"In table2 and rename the column, "TypeCategory" as "Categoty"Go to Append or Append as New and marge the data&nbsp;If solve your requirement, please&nbsp;mark this answer as SOLUTIONIf this comment helps you, please&nbsp;LIKE this comment/Kudos

tebtim19 · Answer

How about if one of the column is have more data than the other column. For example?&nbsp;table 1&nbsp;Type &nbsp; AverageA &nbsp; &nbsp; &nbsp; &nbsp; 15B &nbsp; &nbsp; &nbsp; &nbsp; 11C &nbsp; &nbsp; &nbsp; &nbsp; 10D &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp;table 2TypeCategory &nbsp;AvgE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15F &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16G. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9H. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1J&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp;so this should results of&nbsp;Category &nbsp; &nbsp;AvgA. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15B. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11C. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10D. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9E. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15F. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 16G. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9H. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1J&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2

Forum Discussion

Merging Data

4 Replies

Related content

Merge duplicates data in columns

MERGE QUERIES

Merge data from multiple excel files from multiple sharepoint folders

Async merge risk

Merge statement creates duplicates - Low shuffle merge as cause?