General discussion

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

I have several projects ready and I execute it from an options menu, my question is: when I execute option 1 I need to load the project from that script and that it is executed inside, so on with the other options.  I want each option to be executed within your project. 
example . 
Reclamaciones_Sucursale is  is a projectRecalculo_Cambio_Tasa         is another project
Can you? Could you tell me how to do it?
          Case 1 

Hello,
I work with IDEA in its version 11, I saw on the forum some post which spoke about rdfcreatorlib. I would like to be able to create RDF files on the fly under Python, ideascript or vba Excel but without success. Have you been successful in using this feature?
Thank you
Eric

HI all,
I am new to IDEA and i was hoping someone could assist me. I need to compute the median for multiple grouping. Similar to the summarization tool for the average i also need the median. Hoping someone can help.
Thanks,
RC

Hi Brian and greetings from Ireland,
I've a quick question for you.
My version of IDEA keeps defaulting to US keyboard, regardless of what I've set in windows.
This is driving me mad esp. as the " and @ characters are swapped !!
I can't seem to find a setting to change it to a non-US english keyboard layout.
Any help would be much appreciated.
Thanks,
Phil
 

I am trying to convert from Character to Date format that doesn't include the "day" information, only month and year. I have tried both changing the original column to Date and it doesn't accept the "MM/YYYY" date mask (error message: Invalid Date Mask)
I have also tried to append a new Virtual Date column using the equation @ctod(Field Name, "MM/YYYY") but instead of dates in the column, it shows "Error" in red font in each line under that column.
Thanks for any and all help!