Hi @ozgur.gunes11 

 

I believe crop selection can be done using sheet filter.

 

You can use below PQL in load script.

 

FILTER ACTIVITY_LEAD ("_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" ) = 'Name of activity1' AND ACTIVITY_LAG ( "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" ) = 'Name of activity2' ;

 

Hope it helps.

---

Hi @ozgur.gunes11,

thank you for reaching out.
Please be informed that this can achieved by using the following formula:

FILTER ISNULL(CALC_CROP_TO_NULL(FIRST_OCCURRENCE['Activity 1'] TO LAST_OCCURRENCE['Activity 2'], "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN")) = 0 as a load script on the sheet. You would just need to replace the activities and activity table with your own.

Many thanks for your patience and understanding.

---