General discussion

Hi everyone,
I have a source data (an IMD table) in a project and I am updating this data every month. Generally, I was wondering if there is a way to import the IMD file from another project to a prjoect! I know I can copy and paste into the project but I am looking for another way.
Thanks,

I just uploaded a vidoe on my YouTube channel on using User Types in IDEAScript.  Here is the link to the video and I have attached the script that I used for the demo - https://youtu.be/B56E8LYIuZM

Hello,
I converted a xls file to xlsx file to import itnto IDEA. It seems IDEA does not support xls, right?
Then, I tried to import xlsx (Excel 2016) but question marks appear at the beginning and end of each string (character) cell!
How can I import the data without having question marks?
Please see the images

Hola quisiera de su ayuda deseo llamar un Scrip cuando finalice uno para evitrar tener tantas lineas de codigo en uno solo 

SO, has anyone ever had idea installed on a vm? 
I'm presuming it'd be similar to local install - 1 macine:1 license.
But -
1) Has anyone done it? , and 
2) Was performance acceptable?
 
Thanks in advance!
Rob
 

Hi,
I've attached an example of the spreadsheet that I'm working on. I'm trying to clean up this spreadsheet so that it does NOT show instances when Procedure Code 80307 is billed with G0480, G0481, G0482, or G0483 for the same ID and Service Date. For example, lines 6 and 7 would stay and lines 8 and 9 would be removed from the results. I was trying to use duplicate exclusion function in IDEA, but I'm educated enough with scripting to figure this out. Thanks for any help.

Hello,
Unfortunatelly, I could not find any tasks in IDEA to merge two tables which has two or more keys (multi-index). Visual Connector has limitation and just accepts one key (index) which does not work in my project. Is there any way to do that
Please take a look at Python (Pandas) example attached
 

Hello,

Hi all,
That would be great if you help me in monetary sampling. In ACL, I could ask for (for instance 25) samples and I did it very easily. We sould just print the number of samples we need and then print the summation of  Dollar amount.   I do not know how to do it in IDEA. For instance, how can I extract just 25 (example) monetary samples out of a population?

It has been awhile since I added a video to my YouTube channel but I just added a short one.  I did a fresh install of IDEA and decided to show how I tweak the different options and why I change them.  Short video but hopefully it is something you find useful.

https://youtu.be/FqIXR4wKEBU