[pycelonis] How can push data to analysis?

Hi @sasa.redze12 ,

Although not a direct answer to your question, I have 2 ideas that might help:

1. Isn't there a replace function available? You could use this to replace the old query with the new one (assuming you want to replace all occurrences).
2. Another option, if you plan to do this regularly, is to use a variable which contains the query that should be executed. If I recall correctly you can set variables in pycelonis, allowing you to easily change the query used. I often use this trick to allow a user to set certain logical elements (e.g. notion of an event or abstraction) through drop-downs.

Hope this helps!

Hi Joos,

thank you for taking the time to answer.

Could you elaborate on your first answer? I haven't found a replace function. Maybe someone else knows more?

Your second suggestion is quite informative but probably not applicable to my use case.

I created a copy of a workspace and used the new notebook to generate a list of potential cases where the CASE WHEN statement needs to be adjusted. I then added a new column where I changed the pql statement. now I would like to loop over that list in pycelonis and replace the old pql statement with the new pql statement..

I got everything running except the part where I can change the pql statement within pycelonis and reupload the analysis.

Hi @sasa.redze12 ,

I guess this function should do the trick:

pycelonis.celonis_api.process_analytics.analysis — pycelonis 1.5.14 documentation

Let me know if this helps!