Merge data into a table without creating a new table?

[HarryT]

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!

[Greg_Deckler · Accepted 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.

[HarryT]

Thanks that was it.  I've always used the merge on the left hand side and not directly on the table.