Hi everyone,

I'm currently working on a use case in Celonis and could use some help with a PQL rule I'm trying to build.

I have a table called HOTEL that contains travel records, each with a start date and end date. I want to validate that every single day within the travel period is marked with a "J" in a calendar table called CALENDAR.

For each travel record in HOTEL, I want to:

• Iterate over all dates between STARTDATUM and ENDDATUM.
• Check if the corresponding calendar entry for each date has the value "J".
• If any date within the range does not have "J", I want to flag it as an error.

Does anyone have an idea how to solve this problem in a pql formula as a KPI?

Thanks in advance 🙌
Niels