fixed functions in etl

abarrie23
abarrie23 Member
in Magic ETL

Is it possible to add fixed functions in the magic etl? This is the fixed function I'm referring to.

SUM(SUM(Term length (lookup)) FIXED (BY Document Number))

I can add it in as a beast mode, but can't add it as a formula in magic etl.

image.png

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    FIXED functions only work in beast modes. You can utilize a RANK and WINDOW tile in Magic ETL to do windowing functions.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    FIXED functions only work in beast modes. You can utilize a RANK and WINDOW tile in Magic ETL to do windowing functions.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • abarrie23
    abarrie23 Member

    Very helpful, thanks for the clarification.

Categories