General discussion

Limitation in Joining Databases?

idea_new_user

Forums

Hello,
 
I had joined a primary database to a secondary database using "Records with no secondary match" option where both databases have a common key.
 
After looking through the data in the joined database, I realised that some of these unmatched data to secondary database were found in secondary database.
 
So I re-joined the joined database to the same secondary database using "Records with no secondary match" option. And the output database had fewer records compared to the first join.
 

Pass a date in a dialog box

rehumah

Forums

I have been trying to use this date type var in a dialog box but it is giving me an error
 
Dim StartDate, EndDate As Date
 
Sub Main
StartDate = dlgEnable.TextBox2
EndDate = dlgEnable.TextBox3
Call DirectMCINTExtraction()                
End sub
Function DirectMCINTExtraction
Set db = Client.OpenDatabase(InputFile)
Set task = db.Extraction
task.IncludeAllFields
dbName = FileName +"_INTL.IMD"

Ordinary Least Squares - IDEA

AndreBorges

Forums

Hello everyone,
I have recently discovered some of the fantastic features and capabilities of this great software - IDEA. Now by my curiosity in studying the capabilities of the software I intend to apply to the database some statisticals. So what I intend to do now is: use the IDEA capabilities to estimate some coefficients, and for that I want to use (for now) the Ordinary Least Squares.
 
The goal will be:
Imagine that I have an equation like that:
Y = X * B + E
and: Y  -> only one column

IDEA SERVER

leandrorezende

Forums

Hello everyone from the forum!
I've been working with IDEA for some months already. Since then, I started to face some performace problems  that sometimes delay the deliveries in my work.
So I noticed that the CaseWear provides an alternative version of IDEA as a server that I do not know much about.

Reading statistics in Idea externally

vrbravvo

Forums

Hello All,
 
I am a new user to IDEA and have limited knowledge in the tool usage. So i have two quetions ...
1)  I am trying to read the "Statistics" section externally via a tool named Alteryx which has record count, total net of columns, etc etc  which shows up when we upload a file. I would like to know if there are any log files which stores these information once a file is loaded.

Changing working directory down one level

pcallan0

Forums

Hi again,
I'm having an issue with Client.WorkingDirectory
I'm running a script that places files into a folder "Audit Data".
As part of this script it opens one of these files, places a URL into a field, creates this as an action field, and then looks to another macro to invoke I Explorer
If I put the full path of the second macro into the script it works a dream. However, the macro will be used by different people and so the path will change.

Run macro into IDEA from Notepad++

leandrorezende

Forums

Hello everyone!
I am new in IDEA, but for me the IDEAScripting isn't that efficient taking about the macro editor. 
I search in this forum and realize that some people recomended to use Notepad++ to make life easier.
My question is: What is the path that I should provide to Notepad++ in order to run the macro into
the IDEA?

Subscribe to General discussion