Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All ,
I have 2 tables with 90 % same structure (same no of rows):
Table -1 : col-1,col2,col3
Table-2 : col1,col2,col3,col4
I want to:
1-Add col4 with the same content from Table-2 to table-1.
2-Copy the contents of col2 (Table-2) and Paste it in col2 for Table-1
After that, I 'll remove Table-2, Please advise.
Solved! Go to Solution.
You can perform the following steps in Query Editor.
1. Add a index column for Table-1 and Table-2.
2.Merge Table-1 and Table-2 by clicking “Merge Queries as New”.
3. Expand col2 and col4 from the column as below in the merged table.
4. Select “col2” and “Index”, then remove the two columns.
5. Rename Table-2.col2 and Table-2.col4.
Regards,
You can perform the following steps in Query Editor.
1. Add a index column for Table-1 and Table-2.
2.Merge Table-1 and Table-2 by clicking “Merge Queries as New”.
3. Expand col2 and col4 from the column as below in the merged table.
4. Select “col2” and “Index”, then remove the two columns.
5. Rename Table-2.col2 and Table-2.col4.
Regards,
May be easier to do this in Power Query. What are the sources of the tables? For example, in Power Query, you should be able to do a Merge query between the two queries you have. Are these tables comprised purely of columns imported from sources or are some of these columns calculated?
Otherwise, you might look at NATURALINNERJOIN, INTERSECT, UNION or other similar types of DAX functions.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |