Skip to main content
Question

Is it possibly to use the ADD_WORKDAYS with a workday calendar in a Tranformation for the activity table in order to create the EVENTTIME field?

  • Apr 29, 2022 2:45 PM UTC
  • 1 reply
  • 50 views

salma.zeped
Level 8
Forum|alt.badge.img+2
Is it possibly to use the ADD_WORKDAYS with a workday calendar in a Tranformation for the activity table in order to create the EVENTTIME field?

1 reply

  • Celonaut
  • Jun 7, 2022 6:29 PM UTC

Hi Salma,

 

 

Unfortunately, ADD_Workdays is a PQL native function that can only be used in front side Analysis inside the EMS.

 

Transformations are in Vertica SQL language and do not support PQL (https://www.vertica.com/docs/9.2.x/HTML/Content/Home.htm).

 

Best regards,

Pablo