Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
I have a main table I pull from Redshift. All my queries and measures and reports are from this table.
I have mapping tavble I want to merge with it. I know how to merge tables but it creates a new table.
Can I do with without creating a new table?
The downside of creating a new table would be changing all my formulas and visuals to use the new fields.
In merging into the existing table it only adds one more field.
Thanks!
Solved! Go to Solution.
So generally you would create the query for your second table. You would disable load on this table to prevent it from creating a new table in the model. You would then add a merge step to your first query to merge it with your second query.
Hello
sorry for opening an old topic:
I have tried to follow the steps above, but I am having trouble.
In Excel I have 2 tables:
Table 1 is my centralised spreadsheet with some names and data.
For simplicities sake lets say I have:
Name | ---- | column J
Table 2 contains different data with the same names.
for simplicities sake lets say i have:
name | ---- | column x
I wish to merge a column from table 2 into table 1 without creating a whole new table.
so automatically, if data changes in column x in table 2, it will change in table 1.
I would like the end result in table 1 to be:
Name | ---- | column J (which refreshes data from column x in table 2)
All my attempts so far create a brand new table in the existing spreadsheet or a new spreadsheet.
Thank you in advance for the help.
So generally you would create the query for your second table. You would disable load on this table to prevent it from creating a new table in the model. You would then add a merge step to your first query to merge it with your second query.
Thanks that was it. I've always used the merge on the left hand side and not directly on the table.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |