General discussion
Place project every time I execute a menu option
Forums
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
RDFCREATORLIB
Forums
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
- Read more about RDFCREATORLIB
- 5 comments
- Log in or register to post comments
Median for multiple groupings
Forums
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
- Read more about Median for multiple groupings
- 1 comment
- Log in or register to post comments
IDEA keyboard language
Forums
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
- Read more about IDEA keyboard language
- 2 comments
- Log in or register to post comments
Converting Character to Date Format (MM/YYYY)
Forums
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!
- Read more about Converting Character to Date Format (MM/YYYY)
- 1 comment
- Log in or register to post comments
Problem when trying to obtain a decimal from an input box
Forums
Hello Everyone,
I'm trying to obtain a decimal number inserted by an input box, but the problem is that IDEA shrinks the number, so if I type 1.9 and store it in a variable, the value of the variable is 1 instead of 1.9. Can anyone help me with this, please?
Append Field from my variable
Forums
Hello, how are you?
I need help, I have a variable as a string and I can't insert the value of the variable into the new column. Is it possible to do this?
For example:
Dim instancia As String
Set db = Client.OpenDatabase("Parámetros de contraseña.IMD")
Set task = db.TableManagement
Set field = db.TableDef.NewField
field.Name = "INSTANCIA"
field.Description = ""
field.Type = WI_VIRT_CHAR
field.Equation = instancia 'my error is here, I don't know how to add the content of my variable as a value of the fields.
- Read more about Append Field from my variable
- 3 comments
- Log in or register to post comments
Create a "group key" for duplicate transactions
Forums
TYIA -
I'm working on a duplicate transaction analysis. I want to create a field where each duplicate "group" has a unique number. Any ideas?
Example of what I'm hoping for:
RecNo Vendor Date Amount **Group Key**
1 XYZ 4/20 $20 1
2 XYZ 4/20 $20 1
- Read more about Create a "group key" for duplicate transactions
- Log in or register to post comments
IDEA Script or Function where the result of one task is used in the next task
Forums
I kindly need assistance with an IDEA script or function where the end result in task 1 is used in task 2; Balance in Period 0 is used to get Balance in Period 1, Balance in Period 1 is used to get Balance in Period 2, Balance in Period 2 is used to get Balance in Period 3, ...
I am preparing a loan schedule based on amortization.
Replace cell values
Forums
Hi, hoping to get some help here on this.
Any way to replace text in existing records of a table? e.g. to replace the values of a cell = values of a cell in another column.
Thanks!
- Read more about Replace cell values
- 2 comments
- Log in or register to post comments