Hello, i need help if it is possible.
I have 1 big batabase (like 400 columns and 8mil rows). I need to pick 120 specific columns a array theirs position. Im trying to do this using Extraction with task.AddField function and it work pretty good. But there is a problem i cant solve. When I save this new database using this Extraction and want to do some other activities with it (like new Extraction etc.) all arangement of colums will return to the state of the first big database (according to its history).
Is there any option to set position of columns with task.AddField ignoring history of the original database? Or any other option to array columns to a specific order that will be stable?
Thank you very much for your help
Jan Knize
JanKnize
Offline
Last seen: 7 years 3 months ago
Joined: 01/11/2017 - 03:03
Hi Jan,
I had never noticed that before but I tried it and that is true. That is not what I would expect but that is what is going on. I will send over an email to a friend at IDEA about this and see what they have to say. I guess the only way around this is to store the order of your fields in an array and then populate the task.AddField from the array each time you do an extract. Sorry right now there isn't way that I know of to get around this.
Good luck.
Brian
Hi Jan, which version of IDEA are you running?
I just tried it on 10.2 and it works as expected. So you might have to upgrade to get this to work for you.