Skip to main content

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

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


Reply