Skip to main content
Hi I need to exclude the holiday dates from my activity table Event time column . Can anyone help me on this .Thanks
Hi Rajdeepak, Do you want to exclude them from the table itself, or just in your analysis? For the former:
  • Create a new Data Job transaction after the insert activity tasks
  • Put this code in it: DELETE FROM <activity_table> WHERE <eventtime_column> IN ('<date_1>', '<date_2>');
  • Run the code, the rows of the activity table should now be dropped. You can display the number of rows by running: SELECT COUNT (*) FROM <activity_table> before and after execution.
For the latter:
  • Open your analysis
  • Go to the analysis settings and go to Load Script
  • Type the following PQL statement: FILTER "_CEL_AP_ACTIVITIES"."_EVENTTIME" IN ('<date_1>', '<date_2>')
Unfortunately there is no way to automize this, unless you find a public available table with all the dates, that you can extract to the Celonis EMS. However, you can make it yourself easier by creating a data pool parameter or text variable respectively to the stated solutions and store the entries over there. I hope this is an answer to your question. Best regards, Jan-peter