IDEAScript Questions
Joining Tables when key is between two values (upper and lower)
Forums
Hello, this is my first post on this forum as I am a recent IDEA user.
This question has been crackling my brain recently without any success.
I am trying to calculate the tax retention of multiple employees.
Tax Retention tables have an upper and a lower limit, and 2 features. For the two features I can simply do a join matches only but is there any way to do a key join between a range?
Tax retention table example on the right side.Employee Info on the left.
I want to extract the tax% value for each employee based on the features and its value.
Counting while..
Forums
hi all,
new to idea scripting..
how can i create field that counts while somthing happans in other field?
foe example:
in every row, as long as Employee Number is the same, keep counting 1...2...3...4...
and when the number changes to another Employee, start all over again 1..2..3...
- Read more about Counting while..
- 10 comments
- Log in or register to post comments
Update Dialog based Drop Down Combo Box Selection
Forums
Is there a way to have the dialog update based on the user selecting from a Drop Down Combo Box?
Basically, I'm trying to have the user select a file from the drop down combo box and from this another combo box is populated with the fields from that selected file.
Any help would be appreciated.
Script to Launch Analysis function
Forums
Hello,
I was wondering if it was possible to write a script that will launch a specific analysis. For instance if I write a script where the user wants to summarize something. This would manually be done through the Summarization menu. Is it possible for me to take adavantage of the Summarization menu having already been built to run that anaylsis within the script?
- Read more about Script to Launch Analysis function
- 1 comment
- Log in or register to post comments
Finding the min and max of a date range
Forums
Hi Brian,
I want to write a script or a custom function to find the Min or Max value date range for a particular criteria
For Eg:- in File 1 i have the following data.
Vendor
Date
111
03-Mar-17
111
28-Feb-17
111
01-Jan-17
112
07-Mar-17
112
01-Mar-17
112
28-Nov-16
112
20-Nov-16
I have another file which has vendor codes alone. I want the output as under
Vendor
Latest date
Earliest date
- Read more about Finding the min and max of a date range
- 8 comments
- Log in or register to post comments
Customize Ribbon with Script
Forums
Hello,
I've been looking into this and haven't found out one way or another, but is there a way to use a script to customize the ribbon? I'm looking to install a series of IDEA scripts on multiple user computers and it would be great if I can just have them run a script that does all the customizations of their ribbon so they can use all of the other scripts quickly.
Any help that can be provided on this would be appreciated.
Thanks,
Chris
- Read more about Customize Ribbon with Script
- 1 comment
- Log in or register to post comments
Monetary Unit Sampling
Forums
Hello,
I am an advanced beginner with VBA and novice IDEAScript writing.
I am trying to set-up a macro that prompts the user to select their file from a shared network drive and then process a plan and select the sample. I tried to re-work the process by recording a macro and reviewing the script.
Below I have copied the script generated from the macro. The deficiencies compared to what I would like to achieve are:
(1) Display a prompt allowing the user to select any file type via any file path
- Read more about Monetary Unit Sampling
- 1 comment
- Log in or register to post comments
Sort column
Forums
Hi.
I need to search through a column at an IDEA base by a value. In order to easy my work, I would like to sort this column first, the same way when you create an index just by clicking at the header of the column.
My question, is there a way to create an "Index" using ideascripting or any other way to sort the columns's rows?
- Read more about Sort column
- 5 comments
- Log in or register to post comments
Locate Script Path
Forums
Hi Brian,is it possible to find out at which path the script is running, so I can save the value in a variable.Thanks
- Read more about Locate Script Path
- 10 comments
- Log in or register to post comments
update textbox text
Forums
Hello,
I have created an interface with a textbox. I want to refresh the text of this texbox with the "progress status" of the script ( the script execution manage billions data and can last 10 hours).
I try to use the dlgtexbox with no success. I can easyly define the intial content, but not update it whitout action of the user.
It is possible to change the textbox content ?
Thanks (excuse my bad english, i'm french)
- Read more about update textbox text
- 1 comment
- Log in or register to post comments