Forum Discussion
Solved
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 c...
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.
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.
