SOLVED
how to replace portion of a dataset with new data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
nmitch
7 - Meteor
‎12-02-2021
01:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
4 REPLIES 4
16 - Nebula
‎12-02-2021
01:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-02-2021
01:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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)
16 - Nebula
‎12-02-2021
02:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-02-2021
07:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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!!
