I have a daily process that pulls data using python script and appends to .tde extract. Last wee, accidentally i fed in incorrect data to my python script and ended up appending it to .tde file. Is there anyway to selectively delete rows off of .tde file without having to recreate it. I did try to create filter for my bad records and created new extract. When i try to pull new extract (conditional), i keep getting error that (new extract) file is corrupted.
If I have to recreate entire extract again I will, but I hate for having to do that.