Anyone? Anyone? Bueller? Bueller? Thank you for any help!
1 of 1 people found this helpful
The short answer? No. You can't do this. You're trying to turn "Refresh" into "Archive", which is not it's function. It's function is Refresh
The longer answer is that you CAN do this, but it's unnatural because you're making the tool do stuff it wasn't really designed to do. Here are a few things you might try:
- Create "old" extract". Make a COPY of this TDE ("old extract copy") , put it aside.
- Refresh your extract - "old" extract is now "new" extract and doesn't have the "old extract" historical data in it anymore
- Choose Extract | Append Data From File and grab data from your "old extract copy")
....Now you have 2x the data - new and old.
The other thing you could try is to leverage Data Blending between your "old extract copy" and "new extract" on some sort of key and then comparing rows which share the same key...but this won't help if you are some records which don't MATCH others...
It seems like I can't make an "archive" file, but I found some steps that will help me:
I can refresh extracts selectively, or all at once:
In YELLOW: I'm able to update all at once
In GREEN: I'm able to select my data sources and refresh (or not refresh)
While things may still be messed up if I accidentally hit "refresh all," this will work in the mean time!
Thank you Russell Christopher, your answer was helpful!