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