IDEAScript Questions

Hi,
I am facing an issue with full outer joining of 2 files.I am joining with 2 matching columns.  Blank fields in both files are considered as match and produced a combined row in the joined file.
Attached excel is having 4 sheets.
First 2 are primary and secondary
3rd - Actual output file after joining
4th- Expected output
Joining fields
PON (P), GRNPO (S) ASCENDING
POLN (P), GRNPOL (S) ASCENDING

Hi,
I am using @compif function in equation for appending field through idea script. This works fine in English/United states locale. When I changed locale to French, the equation is not working.
Each condition in @compif is separated by comma (,). But in French locale, it is showing that semi colon (;) has to be used for each condition.
So my code is not working in French/German locales. 

DropListBox only allowing choice#1 to be selected.

Hi Brian,
I am evolving some of my scripts for better usage and I come up with something I am not sure I can do, therefore I am checking with you. I have this part of code, and instead of an array, I would like to insert a dialog box with check boxes as my audit period will expand from location to location and therefore the last 6 months will be always different. Do you know if it is possible? If so, would you mind providing me some guidance?
Thanks,
Giorgia

Hi Brian,
I tried to generate some code by means of the makro recorder in IDEA which allows to delete an original data field. But I did not work. I am searching for a command which turns off the default setting which blocks the delete of original data fields and then turns it on again.
Thank you very much in advance for your help.
Best
Bobby

Hello all,
I have a makro running in IDEA 8.5. However, at some point the makro has a runtime error when I use it in IDEA 9.2. The error occurs when the makro adds a new field to a table. The code is as follows

Hi there,
I require a script that could perform the following tasks:
- special purpose function that could read and import mutiple Excel files in a folder or directory,
- appends all the Excel files and return a single IMD file, the files are stored in an array,
- display the appended single IMD file into a pivot table.

 
Hi Brain,
 
Is it possible to move particular database created during operation from IDEA project folder to sub folder using IDEA script? If yes, can you please provide some guidance or example script. It would be helpful.
Thanks,
Vijay

Hi Brian,
I am trying to develop a script to run a 'Large & Unusual' style extraction over a range of different databases. This requires two seperate functions being:

• direct extraction based on a user defined $value (similar to your IDEA Scripting Tutorial video); and
• direct extraction based on key words in a character field (such as a description field).

My issue is that our standard databases include:

Hi Brian,
I would like to build a script front end, as I have created a major script with lots of minor script each referring to a specific audit testing, where before runnig everything the user is requested to select some or all analysis to perform and also in which order. Have you ever created something like this? In case, would you like to share with me some guidance or advice? I have never created one. 
Thanks, Giorgia