Forum Discussion
HarryT
Helper I
Helper IMerge 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.
Greg_Deckler
Community Champion
Community ChampionSo 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.
HarryTThanks that was it. I've always used the merge on the left hand side and not directly on the table.