How to use data from a table in a Package in another Package via ML?

Hi Leonor ,

Just to understand the second part more : Are you getting any error ?

From my experience: Please use the Package Name or Package Key instead of ID while pushing and please create the Parent folder same as source instance.

Please let me know if his resolves your issue.

Regards

Ayan

Hi Ayan,

I'm not getting an error, I am stuck because I don't know how to start pushing to a Package the data I previously pulled from another Package (which function to use).

Regards

Leonor

@leonor.doris.rodri  AFAIK, the short answer is ... you can not....

You can not modify the data inside the process model.

what you can do is push the data you get from the OLAP table 1 into some table in the process model that feeds the table 2, and reload.

Not sure if I have been clear... feel free to ask for clarifications if needed

I understand the concept, but I'm missing the how ? Could you be more specific on how would it be done?

Ok. Lets call Analysis 1, that has OLAP table OLAP1, and uses Process Model PM1

And we have Analysis2, with OLAP2 and PM2

In PM2 OLAP2 is getting dimensions and KPI's from TABLE2 in PM2

• get the data from OLAP1. probably you will have it in a dataframe
• Update TABLE2 in PM2 with that data, use create_table or push_data_into_table as per here - https://celonis.github.io/pycelonis/1.7.0/reference/celonis_api/event_collection/table_push_manager/#celonis_api.event_collection.table_push_manager.TablePushManager.get_existing_table_status
• do a reload of PM2 - with reload() - https://celonis.github.io/pycelonis/1.7.0/reference/celonis_api/event_collection/data_model/#celonis_api.event_collection.data_model.Datamodel.reload
• And... voilá... if everything works OLAP2 will show the data from OLAP1

HTH!

Thanks for the references and the explanation Guillermo, I think this will work for me!

Glad to have helped you! Have fun!