General discussion

I'm working with a ton of medical claims data. I took claim data from 23 different offices and appened everything together. Then I ran the duplicate key using the recipients ID # (each patient's is unique) and the date of service. The result is 1.8 million duplicate claims. Also, each office has it's own unique billing number. From the duplicate results, they want me to take a specific office and find just the duplicates conencted to it. 

Hi Brain,
Is it possible to move a file inside to '+' as in the attached screenshot?
My child file is not grouped inside the + during the execution. is it possible to move it by code.
 
 

Hello,
I am Alice, I'm new in this forum and on IDEA.
I'm looking for some script/function whitch could : analyse a list with different parameters, and would be able to detect any duplication (perfect duplication on each paramater OR duplication for few parameters) . The result would be : the list with 1 item.
 
EXAMPLE:
my list :
NAME / COUNTRY / AGE
1 - Alice   - France - 30
2 - Paul - Canada - 30
3 - Alice - France - 30
4 - Alice - Spain - 20
RESULT 1 : detect perfect duplication =>

Hi,
I am testing for the risk of employees not recording Annual Leave appropriately. I have 3 sets of data, ie Employee Leave Taken, Network Access and Building Access listing. I cannot get my head around how I can identify instances on an ordinary working day have not access the network or building. The assumption in this scenario is that if the employee is working, they would have accessed both. Of course, there will be some explained reasons.
 
Have any of you performed such test? I am curious to hear how you performed it in IDEA. Thanks.

Hi Brian,
For my project, I want to show a dialog during the execution of the routine.
I filled value to dropdown and everything as my need. 
I want to erase the text box value after an add button is clicked.
But it was not deleting the value.
DlgListBoxArray  "TextBox1", "" 
I tried with the above code. Do you have any suggestions to clear the value in textbox.
Thanks In advance
 
 

Hi Brain,
I have dynamically created a new file and created its column and filled calculated values in the column too. But my issue is that while creating the column, I have created as a WI_NUM_FIELD. But in the result column, it's showing as an editable numeric column. 
Do you know what is the issue? 
While creating the column I have changed the property NewTable. Protect = False, After that set NewTable.Protect = True

Hi,
Has anyone used Benford? I was asked to try and use the Benford on IDEA but I have no idea what parameters I should enter!
Any tips? Thanks!!

Hi,
I have inherited some work done by my previous colleague. Unfortunately, they were not scripted, hence, there were multiple joins and criterias being added to produce an Exception Report. If I have the .IMD file of the final exception report, is there any possibility I can re-run the steps he has taken to reach the final result with fresh set of data?
Thanks.

hi,
I have a rookie question. I cannot seem to get my stratification to work. I have attached a screen shot of my setting and the error message. would anyone know what I am doing wrong?
Thanks!

My audit team is debating whether to use IDEA or the company-adopted Power BI as our primary analytics tool.  What does IDEA do that Power BI (or even open source tools like Python & R) doesn't?  
 
We actually have had IDEA for a few years without heavily utilizing it, so we do not believe we can provide an informed answer to this ourselves.  We considered asking an IDEA sales rep - would they share with us the unique features?
 
Thanks for your help!