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:
- 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.
- 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>')
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.