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

Reply