[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Remove data from all except exempt

I need a generic macro that will ask for which records to exempt from data removal, proceed to obscure or remove data from all except those records, and save as new file name.  

Please provide steps to implement macro if possible?
0
rtod2
Asked:
rtod2
  • 3
  • 2
1 Solution
 
als315Commented:
I see only one way - temporary table, which is filled with record ID and boolean Yes-No. You can mark records to be excluded and make nesessary actions with data (joing your source table and temporary and exclude marked records).
If you can give us example of your table, we can prepare working sample.
0
 
rtod2Author Commented:
ALS, Thank you
What I was hoping for is something generic that I could plug into any database no matter how complex that would basically say clear chosen table xyz with exception of listed records.
0
 
als315Commented:
You should have in temporary table ID field same to key field in your table. SOmetimes it will be long integer, sometimes - no. You should generate structure of temporary table in acordance to source data. It is possible, but not very simple. From my practice I can propose to deside this task individually for every case.
0
 
rtod2Author Commented:
Surely there are folks out there is tons of stuff out there for stripping databases of data before posting.  I am just trying to find an easy way to do that.
0
 
als315Commented:
Normally tables are too big to remove records this way.
I usually use filter for selecting records to be deleted.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now