Skip to main content
Question

Passing parameter value from one sheet to another sheet

  • Feb 29, 2024 8:49 PM UTC
  • 3 replies
  • 128 views

Let say i have predefined columns in sheet2 which has employee details ,So i willl send the employee id from sheet 1 to sheet2 and show employee info based on employee id. How can i achieve it. Please help on this.

 

Note : Dynamically passing employee id

3 replies

  • Mar 1, 2024 9:44 AM UTC

You can try using the analysis variables - PQL statements can be saved as variables and re-used in different parts of your analysis.

This article will help - https://docs.celonis.com/en/analysis-variables.html


  • Mar 1, 2024 5:19 PM UTC

Thanks Sathish on your suggestion. Do we have possibility to perform two actions on button like setting the variable assignment and open tab/sheet?


  • Mar 5, 2024 2:25 PM UTC

Thanks Sathish on your suggestion. Do we have possibility to perform two actions on button like setting the variable assignment and open tab/sheet?

If you are using Views, the Table component supports multiple actions on click:

image