How to filter a Activity table eventtime column using holiday dates

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