A second approach is to make it two steps in EDG, and it sounds like you’ve done the first. For the second, it’s probably simpler to make another graph based on the more complex ontology as the target and write SHACL Rules (i.e. sh:SPARQLRule) which you can include into the target traph to be executed via the Transform tab to do the conversion. After conversion you un-include the rules graph so you’re left with only the real ontology and data based on it. [Bohms, H.M. (Michel)] Indeed. This is my intention. I did the import-step 1 and now I want to do the step 2 (conversion towards more complex multi-class ontology) with indeed shacl/sparql- rules. (well thought of plain sparql first but I guess better as shacl attached to the targets…). I will study the transform option.
The logic of when/if to create new URIs for things is, however, entirely up to you. Re-generating the same URI many times is fine though, as triples processing means that duplicates cannot be written into the graphs. [Bohms, H.M. (Michel)] That is what I hoped (that the deduplication was automatic)! Will start experimenting, thx for the help, Michel Cheers, David On 21 Sep 2021, at 11:21, 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com>> wrote: When I have read in a semantic excel into TBC/EDG I want to convert it to a more structured ontology (ie normalize it) via sparql construct queries. In a sense I am splitting the big nonnormalized table into multiple tables. In this process I have to (I assume) create IDs for individuals that were not in the original table (more as just a column there). Is there some standard approach for this (like create only first time when encountered, reuse when already created )? Thank for pointing me to the right resources! Michel Dr. ir. H.M. (Michel) Bohms Scientist Specialist Structural Reliability T +31 (0)88 866 31 07 M +31 (0)63 038 12 20 E michel.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <image001.gif><http://www.tno.nl/> This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. TNO accepts no liability for the content of this e-mail, for the manner in which you use it and for damage of any kind resulting from the risks inherent to the electronic transmission of messages. -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/452d2e85c60f4002be786f9be49aefd4%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/452d2e85c60f4002be786f9be49aefd4%40tno.nl?utm_medium=email&utm_source=footer>. UK +44 (0) 7788 561308 US +1 (336) 283-0808 -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/034D872D-BA23-4D5A-8D82-83C2EC88BD72%40topquadrant.com<https://groups.google.com/d/msgid/topbraid-users/034D872D-BA23-4D5A-8D82-83C2EC88BD72%40topquadrant.com?utm_medium=email&utm_source=footer>. -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/bc52c5b07e194008a625c1ac5184d7fb%40tno.nl.