Hi
I need to exclude the holiday dates from my activity table Event time column . Can anyone help me on this .Thanks
Page 1 / 1
Hi Rajdeepak,
Do you want to exclude them from the table itself, or just in your analysis?
For the former:
For the latter:
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.