Skip to main content
Question

Hi,I am trying to calculate the so called calendar week of a date-attribute in the course of a transformation. The function to be used is CALENDAR_WEEK; however, I get an error message: "Execution error: Function CALENDAR_WEEK is not supported".

  • October 5, 2023
  • 2 replies
  • 31 views
manuel.haug12
Level 2
Hi, I am trying to calculate the so called calendar week of a date-attribute in the course of a transformation. The function to be used is CALENDAR_WEEK; however, I get an error message: "Execution error: Function CALENDAR_WEEK is not supported". Why?

    2 replies

    abhishek.chatu14
    Level 12
    Forum|alt.badge.img+8

    Are you using CALENDAR_WEEK in the Data Jobs/ Data Transformations ?

    You can try DAYOFWEEK ( date ) which is a vertica sql function, I am asuming that you are mixing the PQL with Vertica SQL and hence the above error.

    Hope this helps!

    manuel.haug12
    Level 2
    • manuel.haug12
    • Author
    • Level 2
    • October 5, 2023

    Hi Abhishek, yes it does! Thank you!

    Community Code of ConductAccessibility statement