Skip to main content
Hello everyone, wanted to know if there's any way to merge a data model from one data pool with another data model that is located in a different data pool?

AFAIK no.

I created a python script to document an existing data model as a list of directives in an excel

then I can mix several of them

and I have another script that creates a process model based on those directives.

 

This is an example of the directives, how I codified them:

TABLA ORIGEN; TABLA DESTINO; K_ORIGEN; K_DESTINO - Relation between 2 tables

@; TABLA_ACTIVIDAD; 'A'; ''. --> Activitity table

@; TABLA_ACTIVIDAD; 'C'; TABLA_CASO --> Case table

@; TABLA ACTIVIDAD; 'CASE_ID', K_ID -->column CASE_ID

@; TABLA ACTIVIDAD; 'ACTIVITY', ACTIVITY_ID --> column ACTIVITY

@; TABLA ACTIVIDAD; 'TIMESTAMP', TS --> TIMESTAMP

@; TABLA ACTIVIDAD; 'SORTING', Sorting --> SORTING

 

And the python code is basically iterate the struct you get with -

dm=pool.datamodels.find(data_model)

 

 


AFAIK no.

I created a python script to document an existing data model as a list of directives in an excel

then I can mix several of them

and I have another script that creates a process model based on those directives.

 

This is an example of the directives, how I codified them:

TABLA ORIGEN; TABLA DESTINO; K_ORIGEN; K_DESTINO - Relation between 2 tables

@; TABLA_ACTIVIDAD; 'A'; ''. --> Activitity table

@; TABLA_ACTIVIDAD; 'C'; TABLA_CASO --> Case table

@; TABLA ACTIVIDAD; 'CASE_ID', K_ID -->column CASE_ID

@; TABLA ACTIVIDAD; 'ACTIVITY', ACTIVITY_ID --> column ACTIVITY

@; TABLA ACTIVIDAD; 'TIMESTAMP', TS --> TIMESTAMP

@; TABLA ACTIVIDAD; 'SORTING', Sorting --> SORTING

 

And the python code is basically iterate the struct you get with -

dm=pool.datamodels.find(data_model)

 

 

Interesting, thanks for sharing Guillermo, I think your idea is great! I also was reading some documentation and I found something interesting regarding export and import tables, maybe another possible solution would be to export all the tables that I need from each data pool into a new data pool where I import those tables, and try to build a new data model with the information of the imported tables manually.

 

With this, I think I can in some way used the tables of multiple data pools to create a new data model.


Reply