You can use the BIND function for 1:N:1 relationship, can refer to the following for the same

BIND (celonis.com)

In the Join Path I can see that it is actually N:1:N situation. So I guess you are on the right track to use PU function. BIND will not be necessary IMHO.

Pulling Data from EKET(N-side) to EKPO (1-side) with PU seems the right solution to me.

You could also pull EKES column to EKPO depending on what you are trying to solve

So in summary I would expect you approach to work. Maybe its worthwile to doublecheck if the "Quotes" are necessary in your syntax.

Or there is just any other column in your table that does not use PU function. If only a single PQL Column fails then the whole "table" will fail.

Hello Abhishek and Manuel,

thank you so much for your input!

I solved the problem by incorporating the PU-function in every column.

BR

Julia Bauer