Custom ETL functions

Idea created by Bob Gill on Feb 17, 2018
    Open for voting
    Score1
    • Bob Gill

    There are a wealth of etl functions available in the ETL Function Reference, but I would like the ability to write additional custom functions which I can reference in layouts and dataflows. 

     

    As as an example, I would like to define variations on the lending calculations (PMT, IPMT, FV, NPV) that use our custom business logic. 

     

    To accomplish this, I would need and editor and debugging tools to validate and verify custom calculations. 

     

    I understand and there will be limitations of the code acceptable to ensure all custom calculations are executable as set theory expressions. 

     

    I also understand custom functions may be not allowed for performance and security reasons. If that’s the case, please let me know.