find & replace help

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.

Datasets

Accepted answers

mceleavey

Hi @nmitch ,

No problem, this is a simple table join:

Hope this helps,

mceleavey_solution.yxmd

All comments

mceleavey

Hi @nmitch ,

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

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

Historical Data.xlsx

October 2021.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703