Skip to main content

IDEAScript Questions

Multiple Drop Down Combo Boxes

I have a dialog that has multiple drop down combo boxes. These combo boxes share a similar attached list and I am trying to figure out a way to prevent the user from selecting the same value on multiple combo boxes. Basically a value can only be used once and I am trying to write the code to check if the user has duplicated a selection. Any advice/help anyone can offer is really appreciated.

Issue with outer join having blank fields

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

@Compif syntax difference in other locales

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. 

Dialog Box instead of array

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

Delete an original data field

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

Import Multiple Excel files and convert to IMD files

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.