Hi Venkat,

Could elaborate a little further what is the purpose of fetching a variable from python and how does this relate to the PQL formula?

Still, below you can find more info pycelonis library

https://celonis.github.io/pycelonis/reference/pycelonis.celonis_api.process_analytics.analysis.html?highlight=variable#pycelonis.celonis_api.process_analytics.analysis.BaseAnalysisDocument.calculate_variables

Best,

Gabriel

HI Gabriel,

Thanks for the response, The use case is I want send automated emails to users with excel report having data extracted from table created in analysis.

while extracting data using python data frame there were some error because of columns having saved formula in it or variable.

Thanks,

Venkat N

Hi Venkat,

Alternatively, you can use Studio functionalities to send emails using data extracted from the Analysis.

celonis.cloud/help/display/CIBC/Send+Email+by+Celonis

I believe this is an easier route to accomplish what you need.

Best,

Gabriel

Hi all,

we are currently also playing with Pycelonis in our CPM environment and have faced exactly the same issue.

Within the analyses we tried to make use of variables, formulars and often it appears that within a formular variables are used.

With Pycelonis it is not possible to extract a table having columns with formulars containing variables.

Our only solution so far was to switch back from the use of formulars to direclty insert the fomular logic into the table column so that only variables but no formulars are left in the table.

After that the data export via Pycelonis is possible but it makes the use of formulars completely useless.

BR

Dennis