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?

  • April 29, 2022
  • 1 reply
  • 3 views

salma.zeped
Level 7
Forum|alt.badge.img
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
  • June 7, 2022

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