Forum Discussion
Merge data into a table without creating a new table?
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.