Skip to main content

In my project, I'm experiencing an issue with PQL pull-up functions.

 

  • I am utilizing pull-up functions because Level 2 and Level 3 Columns are generated based on augmented attributes (User Updated in Celonis). If I use those fields directly in the Logics, I get a common table error as we are pulling data from multiple tables.
  • Using PU_FIRST gives me the oldest first record. Using PU_LAST gives me the latest record.
  • I looked over the documentation, but I couldn't find any alternatives.
  • I tried with BIND and DOMAIN Table Functionalities those are also not working.

 

Please let me know if you have any knowledge on the aforementioned question

 

Thanks in Advnace.

Hello Manish,

 

to better understand the issue, could you kindly provide the table connections of your three columns as well as the PQL code in which you tried using BIND and DOMAIN TABLE.

Furhter, could you please explain what data exactly you want to display in your table, e.g. would your desired end table diplay the data of the first column uniquely or is it possible that based on the second and/or third column some entries of the first column repeat?

Thank you!

 

Best regards,

Bernardo


Reply