how to replace portion of a dataset with new data

[nmitch]

Hi - I have a historic data set and I need to update all the data that is associated with 202110 (field name: CLNDR_YR_MTH_NUM) with new updated 202110 data.

Does anybody know how to properly do this? I've attached sample data for reference. 

I want to keep everything that is in the historic file but only replace 202110 information with the new data. 

[afv2688]

Hello @nmitch ,

Would something like this do the trick?

Regards

[nmitch]

@afv2688 I think we're in the right direction! However, I ran your attached workflow and it looks like it dropped off all the sales for 202110 (see photo below)

[afv2688 · Accepted solution]

Missclicked on a column sorry 🙂

how about now?

Regards

[nmitch]

@afv2688 hmm it looks like I'm still getting the same result as the image above, unless I'm doing something wrong

update: I got it to work, thank you!!