Skip to main content
Question

First Credit Release Date and Time

  • November 26, 2020
  • 1 reply
  • 5 views
.
Level 1
Hi Experts, I am new to Celonis and PQL. I am trying to build a PQL query to fetch, First Credit Release date of of each sales order /Sales Order Item. Can some one guide me on this? Thanks in advance Babu

1 reply

C
Level 0
Hi Babu, Thanks for your question! You can use the PU_FIRST Statement, which returns the first element of the specified column for each element of the given child table. An order by expression can be set to define the order that should be used to determine the first element. The Syntax would be something like this: PU_FIRST ( child_table, parent_table.column [, ORDER BY parent_table.column] ) Hope that helpds, Celonis Data Science Team
Community Code of ConductAccessibility statement