Skip to main content
Question

How can I use Union on PQL to combine data from two tables?

  • August 24, 2021
  • 2 replies
  • 44 views
A
  • Anonymous

I want to combine data from two tables on the frontend using PQL query. Not sure how to do it.

2 replies

D
Level 0
Forum|alt.badge.img

Hello.

PQL Performs implicit joins when using data from several tables.

check this to understand more about joins: https://help.celonis.cloud/help/display/CIBC/Join+functionality

 

Domain_Table can also help you. this creates temporary tables from various columns, and you can use it inside PU_FUNCTIONS.

https://help.celonis.cloud/help/display/CIBC/DOMAIN_TABLE

Thank you.

D

A
  • Anonymous
  • August 27, 2021

Hello.

PQL Performs implicit joins when using data from several tables.

check this to understand more about joins: https://help.celonis.cloud/help/display/CIBC/Join+functionality

 

Domain_Table can also help you. this creates temporary tables from various columns, and you can use it inside PU_FUNCTIONS.

https://help.celonis.cloud/help/display/CIBC/DOMAIN_TABLE

Thank you.

D

Thanks

Community Code of ConductAccessibility statement