Skip to main content
Question

Applying Filter on join Table

  • March 19, 2021
  • 3 replies
  • 52 views
M
Level 1
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

3 replies

Jan-Peter van der Steege
Level 12
Forum|alt.badge.img+26
Hi 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
Visit Our Website: https://www.marcadus.com/en/services/process-intelligence/
M
Level 1
  • malini.natha
  • Author
  • Level 1
  • March 23, 2021
Hi Jan , Thank you for your help. I will try and see whether I can do the same. Best Regards, Malini
A
Celonaut

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

Community Code of ConductAccessibility statement