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.
See the above Merge queries settings. I want the "Code" column to be merged into the OCLCA_Import_Sheet table, based on the common column, RICS NRM Category.
With the settings as seen above, The result is:
The "Table" item in each row is both the columns from the Tbl_RICSNRMCat dataset. I only want the Code column merged. How can I achieve this?
Solved! Go to Solution.
Hi @mike_302 ,
Click this button here:
Then you can choose from a list which column(s) you want to be added to the base table via the merge.
Pete
Proud to be a Datanaut!
Hi @mike_302 ,
Click this button here:
Then you can choose from a list which column(s) you want to be added to the base table via the merge.
Pete
Proud to be a Datanaut!
Cheers! I've done that now and it's served the purpose. I guess I was expecting there to be a way to do that within the merge step, perhaps making things more efficient, but I don't care too much 🙂 Objective achieved.
No worries, glad it's sorted 🙂
The merge/expand steps are separated so you can perform calculations/transformations etc. on the nested tables before you expand.
Pete
Proud to be a Datanaut!
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 |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |