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!

[DavidPrice]

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.

[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.