Custom Function Request
Do you want or need a custom function. Ask for it in this forum and maybe someone will be able to help you out.
Envio de correos por resultado de cada linea de base de datos
Forums
Hola a todos quisiera su ayuda para realizar un funsion en la cual dependiendo del resultado por linea de la base de datos se pueda enviar un correo electronico
Return variables to main
Forums
Hello,
I have a question, i have a script with main and functions, so i can't return variable of function to main. It is possible?
For example:
"MAIN"
......
var_return = Call custom_function1
.....
///////////////////////////////////////////////////////////////////////////////////////////////////
Function custom_function1
.....
....
Return var1
End function
Thank you!
- Read more about Return variables to main
- 1 comment
- Log in or register to post comments
INCLUDE Function
Forums
Hi there,
I have a background in ACL and in ACL, there is a function called the INCLUDE function that will include all occurrences of a specified character or characters from an existing character string. As an example, INCLUDE(Address_Field_Name, "0123456789"), will give me all of the numeric characters from the address field, regardless of where they are located in the field or how many times they occur.
- Read more about INCLUDE Function
- 7 comments
- Log in or register to post comments
Automate Daily File Import
Forums
Hi there,
I am working in the IDEA server version and am trying to write a script that will automatically import a file that is sent to our server daily. The file name has the prior day's date at the end. I have tried using a function that works when I evaluate it within the 'Criteria' window, but within my script I keep getting an error. My line of script with the error looks like this:
- Read more about Automate Daily File Import
- 1 comment
- Log in or register to post comments
Summarization function
Forums
Hi all,
I have created a function for summarization task (Function Summarize) that is called from other Function (PerformAction) - the main aim is to add loop that will be setting 3 different fields for sumarization tasks - task.AddFieldToSummarizet and task.AddFieldToTotal (task is a variable Action2A_Summarize).Does anyone came up with a code that passes array of options within the loop for those 2 task within summarization task?
My code so far looks like this but I think it will fail:
- Read more about Summarization function
- 2 comments
- Log in or register to post comments
Numbering
Forums
Hello,
im new to IDEA and could need a little help.
This is what i had: This is what i got after using @GetPreviousValue: This is what i need:
- Read more about Numbering
- 7 comments
- Log in or register to post comments
Normal distribution function
Forums
Hello,
Does anyone have am IDEA function available to calculate:
- the normal distribution for a specific mean and standard deviation, just like Excel does with NORM.DIST function?
- the inverse of the normal cumulative distribution for a specific mean and standard deviation, just like Excel does with NORM.INV function?
Thanks in advance for your help.
Cheers
Drumond
- Read more about Normal distribution function
- 2 comments
- Log in or register to post comments
Concatenate character fields
Forums
Hello! I am performing analysis on bank account information and have 2 fields, both character: routing number and account number. I want to concatenate the two to create a single number. For example:
Routing number: 12345
Bank account number: 987654321
Result: 12345987654321
- Read more about Concatenate character fields
- 2 comments
- Log in or register to post comments
Last Known Change Record
Forums
Hey Brian,
I am not sure if it would make more sense to create this logic by custom function or script. Essentially I have a data set that contains records regarding changes made by users to reservations.
- Read more about Last Known Change Record
- 4 comments
- Log in or register to post comments
Hash/Digest function
Forums
HI Brian & everbody else!
There are times when we would rather not propagate multiple copies of sensitive data, and unique hashes or digests would suffice. This also can help to make long fields short to save space without comrpomising uniqueness.
I'd like to create a custom function that calculates a SHA (or MD5) hash of a character string.
Microsoft has a crypto API that has hash functions available, but I don't have the knowledge to call it from a custom function.
- Read more about Hash/Digest function
- 8 comments
- Log in or register to post comments