IDEAScript Questions
Get numeric value from other database instead of Join
Forums
Hi,
Can you help me with a script to obtain a value from other table, or populate a temporal array obtaing values fromo other table using a common code_type field on both tables as criteria to search value range
I have a Account Receivable, and need to obtain a percent value from other table (table B) using the client_type and age_range (lets say 90 days) from table A, so I need to search wath %value has the table B comparing the client_type.
Example
Table A
Type : 3, age: 500 days
Array
Forums
Hi Brian
I wish you the vest best for the future. I was just wondering if there is any update in relation to the query (using an array to identify the length of time that products sold had been held in stock using the LIFO method) That I had raised with you back in February.
Thanks
Karl
- Read more about Array
- 1 comment
- Log in or register to post comments
Inputbox string - remove special characters
Forums
Hi Brian,
I'm back again :-)
I'm running a script and I would like user to be able to enter a case reference which is stored as a string.
Much later in the script this will be used to create an output filename.
The following lines allow me to get the input, tidy it a little, and then pass it to create the filename.
caseref = InputBox("Enter your case reference", "Case Reference", " ", 815,475)
caseref = UCase(LTrim(Left(caseref, 20)))
dbName = pfolder &"\Calculations for" +caseref +".IMD"
All of this works without any problem.
- Read more about Inputbox string - remove special characters
- 3 comments
- Log in or register to post comments
Help with dates within an idea script
Forums
Hi Brian,
I'm hoping you can help with the following please.
I'm building a macro to calculate interest on customs debts. The applicable annual rate is the one on force at the date of import, and currently I am using a very long compif statement to assign the appropriate rate.
Each time there is a rate change, I add the date of change and the rate to the front of the compif statement (e.g. this month the rate changed to 6.25% so I added IMPORT_DATE >= ""20240701"", 0.0625).
- Read more about Help with dates within an idea script
- 10 comments
- Log in or register to post comments
Optional parameters in functions
Forums
Is it possible to use optional parameters in functions?
"optional" is a known command, if you type it in idea script.
- Read more about Optional parameters in functions
- 2 comments
- Log in or register to post comments
Idea Progress Bar
Forums
I have a custom script I wrote that does a series of DB lookups where I am issuing a search command to a record set to find a value. It works perfectly. The only drawback is it may look as if the program is frozen. Is there a way to build a progress bar into it while it is running.
Thanks,
Randy
- Read more about Idea Progress Bar
- 2 comments
- Log in or register to post comments
How to transpose data to change row into column using IDEAScript
Forums
Hello, i want to ask on how to code using IDEAScript to transpose data from row to column. here is the scenario :
I got an excel source data and the first row can't be used as field name while each row that has data is divided with blank row one after another. the writing format is like form with first column contains form labels and second is the answer. i put the screenshots of the expected result if i transpose the data below. i also put the test file below.
Is there a way to script this kind of data transpose in IDEA?
Thank you.
Smart Analyzer Settings
Forums
I have smart Analyzer project for Payroll. I break it up into 8 databases that represent unique population for payroll. I apply unique setting from a parameter file. I have to tag 8 database and set the parm file against 8 databases and 7 different tests.
Is there any way to streamline this process. I do have the tag file saved and the parameter file saved but have to use them as indicated above.
Thanks,
Randy
- Read more about Smart Analyzer Settings
- 2 comments
- Log in or register to post comments
Refresh IDEA with IDEAScript command
Forums
Hi,I am using Python together with IDEAScript and when I created IMD files I have the problem that at the end I need to manually click the refresh button in IDEA in order to refresh IDEA and that it displays the IDEA-files.
I wondered if there is an IDEAScript function that I could add at the end of my code to automatically refresh? I checked the help section in IDEA, but couldn't find any command.
- Read more about Refresh IDEA with IDEAScript command
- 2 comments
- Log in or register to post comments
Same Script for multiple Tabels
Forums
I currently have the usecase for one script to run for several tabels with different names. I wanted to ask if there is an easy way without having to change a lot in the scipt. For the part of the name which changes, I have already declared a variable.
Thanks in advance!!!
- Read more about Same Script for multiple Tabels
- 1 comment
- Log in or register to post comments