Member since
03-28-2018
3
Posts
0
Kudos Received
0
Solutions
03-29-2018
12:33 AM
@Rahul Soni If you have been getting this duplicate table name error try the below solution Solution: Check for and delete the existing extract BEFORE using the dataextract.Extract() method. So my original code was this: ############BAD############ # #create the extract# try:
# #try to create the extract file
# tdefile = tde.Extract(dataFolder+'DataExtract.tde')
# except:# #if the file already exists, delete it
# os.remove(dataFolder+'DataExtract.tde')
# #create the file now
# tdefile = tde.Extract(dataFolder+'DataExtract.tde') My new, working code does this: ############GOOD############ #if the extract already exists, delete it.
if os.path.isfile(dataFolder+'DataExtract.tde'):
os.remove(dataFolder+'DataExtract.tde')
#now create a new one
tdefile = tde.Extract(dataFolder+'DataExtract.tde') Hopefully this helps!
... View more