IDEAScript Questions

Hello,
I am working on a project that involves populating multiple drop down lists via arrays with the field names from a previously selected database. There is also an array that is being used to populate information for another part of the process. The problem I am running into is that once I add in my 3rd drop down menu (4th time an array is being used) I keep getting the error: "Subscript out of range". Am I missing something that would clear the array each time I use it? Below are some sections of my script:

Hello everyone
Can somebody please assist if this is possible. I have over 100 files with data and 100 coresponding files with headers (column names of the data files). All 100  data and header files are in different names, but sharing names as pears. The header files have all the headers in one column (all headers are in rows). Thus, I was wondering if there is an IDEA script or way to traspose the header files first and then append each trasposed header file to its corresponding data file. Please help if possible.
Thank you. 

Hi,
 
is there a way to script deleting a parent database without deleting child database. When I do this manually it comes up with the option: would you like to delete child database? Is there a way to script this? (havening been able to find anything)
thanks for your time,
 
Mike

Hi,
I have developed this script.
I want it to get the value Materiality and return a new field with YES or NO for additional filtering (i.e. PerfMateriality and Sampling).
The code is stuck on task.AppendField field as Syntax Error.
Could you please help me?
This is the code.
Sub Main
Dim Materiality As Long' Could set to 2 decimal places & do similarly for the following two variables
Dim PerfMateriality As Long
Dim SamplingThreshold As Long

I'm currently trying to identify duplicates in our vendor file. I'm tackling the issue of using the address, because I'm able to find a lot of potential duplicates which we would not otherwise identify (e.g. John Doe and ABC Corp at 1234 Main St).
The manual algotrithm which I'm doing currently works on three criteria:

Is it possible to export the history to a txt file from the IDEA script?

Hi, 
I am trying to import a csv file using an ideascript. I understand that there needs to be a corresponding rdf file otherwise the import wont work. Is there a way to create the rdf file using ideascript?
thanks,
 
Mike

Hi,
Is it possible to rename the column of a database based on its position rather than its name? For example, change the last column of a database to a standardised name.
I am looking for something similar to how you index by columns with a data.frame or matrix in R and Python. 
thanks,
Mike

Hi There
May you please possible assist. I was wondering if there is an IDEA scripting function, methode or piece of code in IDEA that will allow IDEA to automatically click on "YES" when the script is asking for the existing database to be replaced. The problem I have currently is that I have large scripts and i have to sit there and press yes everytime there's a database that needs to be replaces, in order for the script to continue running.
Thank you.  

Hi there,
I have the following two tables that i'm trying make a test as below:
Table 1
User | transaction 
User1 | transaction1
User1 | transaction2
User1 | transaction3
User1 | transaction 4
and
Table 2
Case ID | 1st transaction | 2nd transaction | 3rd transaction
Case 1 | transaction1 | transaction 2 | transaction 4