IDEAScript Questions
Validate matching fields for join
Forums
Validate matching fields for join
- Read more about Validate matching fields for join
- 3 comments
- Log in or register to post comments
Multiple Drop Down Combo Boxes
Forums
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.
- Read more about Multiple Drop Down Combo Boxes
- 8 comments
- Log in or register to post comments
Change hierarchy in database display
Forums
Hi,
- Read more about Change hierarchy in database display
- 1 comment
- Log in or register to post comments
Issue with outer join having blank fields
Forums
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
- Read more about Issue with outer join having blank fields
- 3 comments
- Log in or register to post comments
@Compif syntax difference in other locales
Forums
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.
- Read more about @Compif syntax difference in other locales
- 18 comments
- Log in or register to post comments
DropList issue
Forums
DropListBox only allowing choice#1 to be selected.
- Read more about DropList issue
- 10 comments
- Log in or register to post comments
Dialog Box instead of array
Forums
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
- Read more about Dialog Box instead of array
- 5 comments
- Log in or register to post comments
Delete an original data field
Forums
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
- Read more about Delete an original data field
- 1 comment
- Log in or register to post comments
Add new field to a table
Forums
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
- Read more about Add new field to a table
- 2 comments
- Log in or register to post comments
Import Multiple Excel files and convert to IMD files
Forums
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.