General discussion
How to make a join with scripting - Criteria problem
Forums
Hi!!
While I was studying, i tried to make a join between 2 databases that I already have both IMD files.
I have a criteria inside IDEA, but I can't use the same criteria using IdeaScripting..
Would you mind helping me to fix it? Please!
Set db = Client.OpenDatabase("SR3_STEP1.IMD")
Set task = db.JoinDatabase
task.FileToJoin "SR3_STEP2.IMD"
task.IncludeAllPFields
task.AddSFieldToInc "ID_SR"
CIDA
Forums
Just got an email that I qualify to take the CIDA exam and wonder how useful having that certification actually is? I'm a CFE and have the IIA's Certified Govt Audit Professional.
- Read more about CIDA
- 1 comment
- Log in or register to post comments
Complete Guide to Auditing with Data Analytics Tools
Forums
I have this and it breaks down various areas to audit (AP, AR, GL, etc) and gives a list of things to do but no examples of how to do them using IDEA? Is there somewhere that provides this information? Is there a script out there or in the Analysis area? Thanks in advance.
Webinar on Custom Functions
Forums
I did a webinar for SAMA on custom functions. It is not available on YouTube if you want to see it. It is about 45 minutes long, first 30 minutes is my presentation and the rest is questions. I go through three items, one is a simple custom function to show how they can be created, two is showing how you can take a fairly difficult equation in the Equation Editor and make it more readable as a custom function and third is creating custom functions that aren't available in the Equation Editor.
- Read more about Webinar on Custom Functions
- Log in or register to post comments
Empty Tables corrupting joins
Forums
Hello,
- Read more about Empty Tables corrupting joins
- 1 comment
- Log in or register to post comments
Thank you Brian
Forums
I want to thank you Brian and others who helped me with setting up and running a script automatically. I got upgraded to version 11 and so far am just using Task Scheduler to run the script I needed. It runs like a Ferrari and is saving me about a days worth of work so THANK YOU so much!
- Read more about Thank you Brian
- 3 comments
- Log in or register to post comments
cost of IDEA and SDK
Forums
Hello @ all,
first of all many thanks to this forum. Here you will always find inspiration for new projects and competent help and advice!
I don't know if someone can help me with my current problem.
In my work I regularly use IDEA10. In this context I have made a suggestion for an extensive macro to make certain processes more efficient. On the part of my German employer I was informed that a corresponding macro would not save any time. I spare myself a comment on this.
- Read more about cost of IDEA and SDK
- 1 comment
- Log in or register to post comments
Open file - Address inside IDEA Script
Forums
Hi!
I have some questions:
1) Is there a way to open all files from a folder? -> and put the different names (addresses) to an array?For example, now I ask the user using Input to say the address from the file, but I would like to process a lot of different .xlsx files at the same time.
2) If the user write the address as folder1/folder2/open.xlsx
Is there a way to break the string and get only the "open"?
Thank you!!
- Read more about Open file - Address inside IDEA Script
- 6 comments
- Log in or register to post comments
Free Idea Internal Resources
Forums
hi Brian
I have a program that creates some databases and delete them while the script is running, the script loops few hundred times until it finishes.
somewhere along the execution path the script crashes, in different places, with Idea internal error message. The reason I think it is resources not freed correctly issue is because when I restart the PC I can progress from a saved point to the next crash and so on until the script reaches not so safely the promised land.
- Read more about Free Idea Internal Resources
- 9 comments
- Log in or register to post comments
Convert text to number
Forums
Hi everyone,
I'm new on IDEA and I'm doing my first scripts.
I would like to convert a string into a number format as for example "102.23", I found the function @Val but this one only works on the first figures: @Val(102.23) returns 102.
I could combine this function with the function Split to work arround the coma, but it should exist a simpler method, and I can't find it.
Which funtion should I use?
Thank you very much for your help
Mac
- Read more about Convert text to number
- 1 comment
- Log in or register to post comments