IDEAScript Questions

Hi, I am new to using IDEAScripting. I would like to define global variable(s) in the main sub that I can then use in functions. Could you give me an example of how to do this? I am doing this so that I can change the name of the database to re-use the macro. Currently I am having to define the same variable in each function. 
thanks for your time,
Mike

Hello,
I'am new with IDEAScript, and i have some doubts...
I made an Script using External Variavels. So, IDEA made a file with extesion name ".EVARS". But, when i build the file for EXE, the build just dont save the external variavels file and the build does not call it too.
 
My questions is, exist any other way to compile with in the External Variabels our just put them in ISS file?
I just dont wanna use both files...

Is there any information about the time duration that some IDEA actions take? I have a large script and sometimes with a file with more than 1.000.000 records with a rather big size the script takes around 8 to 12 hours to finish.   

Hello,
I am looking for a script that allows me to export multiple databases (4 standard databases) to one Excel file in multiple tabs, such as: 
- IDEA Database A = Excel tab A
- IDEA Database B = Excel tab B
I found a script on this forum where you can indicate which IDEA databases should be exported to one Excel file, because in my case there are four identical IDEA databases at all times, I would like to leave out this window and export the 4 databases concerned to one Excel file with multiple tabs by default. 

Hi,

Hello,
I just want to know how to unpivot columns in IDEA. The example below is what I am trying to accomplish.  Thanks for the help!
 

Name           Grant Name          Amount

John                 Grant 123               1,000

I have a script to create an array with the fieldnames of a database. But for a check i need to exclude two fields of which i know the name. But is it possible to search the array for a match and remove that row in the array?

Hi.  I am working on a project to compare a data set DATATABLE with customer names (CUSTNAME field) against a separate table KEYWORDS with 1000 words.  I want to either filter, or extract/return, results if there is a the CUSTNAME field contains any word in KEYWORDS.
Is there a way to do this?  I'm thinking probably a loop to go through each of the data elements in the key words table and then to do a "contains" comparison with isini or something?  Just wanted to see if there was a way, or code available, to do this.  Thanks!

Hi @ all,
i tried to compare 2 pictures within a dialog.
But it doesn't work. Has someone a suggestion to solve the problem?
Thanks a lot
Jan

Hi Brian,
Hope you're doing good. Am looking for a Idea script which can be used to knock off positive and negative values from a data set taking into considerations the GL codes as well.
Currently, I am able to perform this in an excel file by using the below mentioned formula,
“=(COUNTIFS($B$2:B2,B2,$A$2:A2,A2)<=MIN(COUNTIFS($B$2:$B$1000000,-B2,$A$2:$A$1000000,A2),COUNTIFS($B$2:$B$1000000,B2,$A$2:$A$1000000,A2)))”