Question
Applying Filter on join Table
Hello Community, I am a new member, learning Celonis. while doing the exercises(I am following a PDF document) I got the following error when
trying to apply filter on join table.
Error parsing filter: CDHDR.UDATE >= 01.06.2014 caused by: Lexical error at line 1, column 16. Encountered: \\u2018 (8216), after :
The following is the statment i gave:
CDHDR.UDATE >= 01.06.2014
Could anyone please help me to rectify this.
Thank you,
Malini
+26Hi Malini,
If I remember correctly, I had the same problem. I got around this at the time by using a time filter, instead of a user defined filter. Unfortunately, I dont know what a structural solution would be.
Best Regards,
Jan-peter
Hi Jan ,
Thank you for your help. I will try and see whether I can do the same.
Best Regards,
Malini
Hi Malini,
I would suggest using a filter that you can adjust. What you can do is make one in the parameter section and select 'DATE' and set it to a date you want to use. I usually use a <%=StartDate%> so I can ensure that all the tables are filtering on the same date. Let me know if you have any questions.
Andrew
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.