General discussion

I found this interesting article by Dave Coderre on identifying duplicates.  Thought it might be interesting to some people.

https://www.linkedin.com/pulse/identifying-duplicates-effectively-david…

Data science is being very popular these days and there are many fields in which it is being used. So, data science courses and training are provided to people who are interesting in learning and now one can get knowledge about data science even online on regular basis. Along with that, one can get trained in machine learning too.
 

Dear All,
I'm looking for a formula or a script that help me to :
First, split the dial code (caracter value ) from 8 digit to 1 in the file A, Second; perform a VLOOKUP on the File B of these spliter fields.
Thanks.
Ahmed.
 

I have 30 million records in Idea and now i want to create pivot table and summarization based on certain fields but i am getting an error that it can not display more than 32K records. Please let me know the other way in idea (scripting etc) which might help me to analyse the information.

Dear All,
I would like to know if is it possible to add the name of the file imported by creating a new field in idea.
Thank you.

Have been trying to open an IDEA database file from within IDEA and when I try to open the file an error box comes up with the statement "Unable to Open Database". All other database files in the working directory can be opened except for this one database. Could the database be corrupt? I have tried renaming the database in Windows, moving the database to another folder location and nothing seems to fix this error.
Any help would be appreciated :)
 

With 10.3 there has been further enhancements to the graphical reporting with Discover and Visualize.  I used them recently to report to Senior Management which was very well received. I wondered if anyone had used IDEA to integrate with Tableau or Power BI to improve such reporting? If so, what were the benefits?

I just added a series of 11 videos on my YouTube channel that walk you through creating a dialog in IDEAScript.  All the total time for the 11 videos is about two hours.  The vidoes cover the following:

CaseWare has updated their OUtliers Detection utility.  You can get the update from the IDEA lab (http://ideascripting.com/IDEA_Lab/idea-lab-home-page).

Hello All
 
Thanks Brian for this helpful site, it has really helped me a lot of times!
 
I would like to ask you the following:   I have a set of scripts that I run monthly in diferent projects, of course I do not copy the scripts to every project, but I run them from a specific folder.