General discussion
New Job
Forums
Hello everyone, if you have been wondering why I am not around as much as I have used to be it is because I have changed jobs. After 30+ years with the government of Canada I have retired and joined CaseWare IDEA as an Industry Strategist (Solutions Lead) on their Industry Team. This will be a great challenge but after five weeks with the company I am loving it. Because of this change I no longer have time to keep up with the boards on a constant basis, also I no longer have the time to create special scripts for people. If you have suggestion
- Read more about New Job
- 2 comments
- Log in or register to post comments
Stack Overflow Error
Forums
While using the function Mid(currentLSD, 5, 2) I am getting stackoverflow error .
- Read more about Stack Overflow Error
- 1 comment
- Log in or register to post comments
Date overlap with lots of data
Forums
A while back, I used the script in the link below to identify hospital overlap.
https://ideascripting.com/forum/overlapping-dates
Hospital overlap occurs when a provider bills a patient for service at doctor's office, home, etc. while the patient is actually in the hospital. The script in the link did identify the overlap. For example:
Provider
Start Date
End Date
Over Lap
- Read more about Date overlap with lots of data
- Log in or register to post comments
Data Validation
Forums
Hi all,
I have recently moved roles from an commercial role to a consulting role. With the new role, I have noted that I would have to request for data extracts in order to perform analytics.
Would you be able to provide me with some tests that you would do to validate the data for completeness? Some of the tests I perform are:
- identifying blanks in key fields,
- verfiying the transaction dates to ensure the audit period is captured,
- number sequence check (where numbers are meant to be in sequence),
- Read more about Data Validation
- Log in or register to post comments
SAS
Forums
Good day Brian, I am confronted with the need to analyze numerous files in the SAS native structure. Is there a process whereby IDEA can read SAS files directly? They are available in a CSV flatfile structure as well, but they run to about 156,000 kb. Thanks, Bryan
- Read more about SAS
- 1 comment
- Log in or register to post comments
Unprotect a column
Forums
Hi Brain,
I have extracted a single record to from source file to extracted File.
Then I need to edit the values in this column. Is it possible.
I tried to enable protect = False, but it's not working. I tried with the below code. could you please check this.
Dim db As Database
Dim table As Object
Dim newFieldObject As Object
Dim newFieldName As String
Dim newField As Object
Set db = Client.OpenDatabase(dbName)
Set newField = db.TableManagement
Set table = db.TableDef
- Read more about Unprotect a column
- 1 comment
- Log in or register to post comments
ODBC with imd file as the source
Forums
Is anyone aware if its possible to connect Excel to an IMD file using ODBC - ie the IMD file is the source.
- Read more about ODBC with imd file as the source
- 4 comments
- Log in or register to post comments
Using IDEA to prove/disprove a theory
Forums
I'm wondering if it's possible to use IDEA (v 10.4) to either prove or disprove a theory. The theory is that training (online and classroom) improves turnover. I have access to all the tables in the HR database which has the training area. I pull termination dates and course completion dates but that is not enough to prove causation. Has anyone done anything along these lines, maybe marketing/sales?
- Read more about Using IDEA to prove/disprove a theory
- 1 comment
- Log in or register to post comments
Comparing Multiple Fields for Highest Value
Forums
Good afternoon,
Does anyone have a crafty way to compare multiple numeric fields (More than 2, I would otherwise use the @MAX function) in a database. I would like to take the highest numeric value and then do some testing on that... Thanks for any insight!
- Read more about Comparing Multiple Fields for Highest Value
- Log in or register to post comments
Time overlap
Forums
I have over 5000 time entries and I'm trying to check for overlaps on the same dates. I've tried using a date overlap script that I saw on here, but I cannot get it to work for the time.
That data looks like this:
DATE
FIRST TIME IN
FIRST TIME OUT
2015/12/07
16:15:00
18:15:00
2015/12/07
19:00:00
21:00:00
2015/12/10
07:30:00
09:30:00
2015/12/10
12:30:00
14:30:00
2015/12/10
14:45:00
16:45:00
- Read more about Time overlap
- 1 comment
- Log in or register to post comments