Skip to main content
Question

PU_FIRST question

  • August 16, 2021
  • 2 replies
  • 13 views

2021-08-16 19_45_37-WindowPlease see the screenshot showing sample data, we want to show waste transfer movements which go out of a source storage unit (Movement type 319) to a destination (Movement type 0) and then return. I can make the PU function work well when there is one waste movement however there are many times that the stock is moved out and back, and out and back and I can't make Celonis line up the 2nd out and back movements

2 replies

joos.buijs
Level 10
Forum|alt.badge.img+2
  • Level 10
  • August 17, 2021

Hi @sarah.barne12 ,

 

I don't fully understand your problem, but you could also look into the 'REWORK' PQL function and maybe the 'ACTIVATION_COUNT' PQL function. This might help!


  • Author
  • Level 1
  • August 17, 2021

Unfortunately those only work on the activity table and this table isn't the activity table.

 

Many thanks,

Sarah