Field Transform Groovy Function with Switch Statement cannot handle variable

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Field Transform Groovy Function with Switch Statement cannot handle variable

      Hello again,

      maybe someone of you ran into a similar problem and might have a hint for me.
      I'm struggling at the moment with a field transform.
      The groovy function there is supposed do the following
      Check if KPI (_input1) is Price -> then return value (_input2)
      check if KPI is amount -> then check if value = PlanSource then return PlanTarget [PlanSource and PlanTarget are both variables), else check value

      example:

      #1Price150.0
      #2Amount1000.0
      #3Amount2416.0



      $PlanSource = 2416.0
      $PlanTarget = 600.0

      This should result in:
      #1Price150.0
      #2Amount1000.0
      #3Amount600.0




      I tried it with an if-statement as well as switch. Unfortunately both don't work. Somehow the function cannot assert the input with the variable Value. If I type in a value instead of the variable PlanSource, the snippet works.

      Both work in groovy webconsole: groovyconsole.appspot.com/

      Java Source Code

      1. PlanSource = ${HPPlanSource}
      2. PlanTarget = ${HPPlanTarget}
      4. //KPI = Price -> Value
      5. if (_input1 == "Price") {
      6. return _input2;
      7. }
      9. // KPI = Amount
      10. // Amount = Plan of source -> Plan of Target Project
      11. else if (_input2 == PlanSource) {
      12. return PlanSource;
      13. }
      14. // Menge <> Plan -> Amount of SourceTable
      15. else {
      16. return _input2;
      17. }
      Display All




      Java Source Code

      1. HPPlanSource = ${HPPlanSource}
      2. HPPlanTarget = ${HPPlanTarget}
      4. switch(_input1) {
      5. // if KPI = Preis return input2 (Preis value)
      6. // if KPI = Menge
      7. // if input2(value) = HPPlanSource return HPPlanTarget
      8. // else input2 (Menge value)
      9. case "Preis":
      10. return _input2;
      11. break;
      12. case "Menge":
      13. switch(_input2){
      14. case HPPlanSource:
      15. return HPPlanTarget;
      16. break;
      17. default:
      18. return _input2;
      19. }
      20. default:
      21. return _input2;
      22. }
      Display All
      Does anybody have an idea?

      Thanks in advance.

      Bjoern

    • I found the solution.
      In the end the issue was with the type. (to clarify: the values did not get replaced in the beginning, it did not run into an error)
      When I specified in the groovy job for _input2 as float it worked.

      I had to split up the extract to keep it simple in the ETL, since KPI (_input1) had also a comment element with string values (_input2).
      But after splitting that up and putting a table union in the end, it worked like a charm.