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