General discussion

Hi everyone, some of you may of noticed that I am not posting much right now and haven't been responding to posts.  I had a fall over the Christmas holidays and ended up with a mild concussion, nothing to worry about but I haven't had the energy lately to reply back to everything.  I am getting better everyday and hopefully will start to respond to peoples posts as I feel up to it.

Thanks

Brian

Hello, 
Would anyone be able to tell me how to add a specified number of months to a date? I'm looking for a function that has the same functionality as Excel's EDate function. For example, if I have a date of 10/1/18 in one column, and a number of "11" in another number, I would like to append a column that will add 11 months to 10/1/18, to return 9/1/19. 
Thanks!

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: