Skip to main content
Question

Passing parameter value from one sheet to another sheet

  • February 29, 2024
  • 3 replies
  • 7 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

Forum|alt.badge.img+6

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


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


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