find & replace help

[nmitch]

Hi - I have a historical data set that holds 2 years worth of data with a field that states which month/year it's associated with. I have an additional October 2021 dataset that I need to replace with what is currently in the historical data. 

I have tried using the Find Replace tool however it isn't allowing me to replace just the October 2021 data, it looks like it wants to replace everything.

Hoping someone is able to assist. 

[mceleavey]

Hi @nmitch ,

Can you mock some data which representative of the format of your data and show us what you want?

M.

[nmitch]

HI @mceleavey - I've attached two mock datasets. I am looking to take the 202110 sales number in the Historical Data file and replace it with the 202110 sales number in the October 2021 file.

Hope that helps

[mceleavey · Accepted solution]

Hi @nmitch ,

No problem, this is a simple table join:

Hope this helps,

M.