You can always import data and look at it as you develop queries. The pattern Richard recommended - starting with SELECT is almost always the way to go. Then, if a query does not return what you expect if you can’t quite understand why by looking at data, simplify it systematically by removing one triple match at a time until the issue becomes clear.
> On Nov 21, 2019, at 2:45 AM, 'Bohms, H.M. (Michel)' via TopBraid Suite Users > <[email protected]> wrote: > > Hi Irene, Richard > > Thx for the explanations! > > I had not realised that with the sheet-import empty cells were not generated > at all! > > Greetings Michel > > > > > > Dr. ir. H.M. (Michel) Böhms > Senior Data Scientist > > T +31888663107 > M +31630381220 > E [email protected] > Location > > > <image001.gif> > 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. > > > > > Van: [email protected] <[email protected]> Namens > Irene Polikoff > Verzonden: Wednesday, November 20, 2019 11:35 PM > Aan: [email protected] > Onderwerp: Re: [topbraid-users] contsruct query question for sheets > > Because if row 1/column y cell is empty, you do not have triples that match > this graph pattern: > > ?unitCell ss:row 1 . > ?unitCell ss:column ?y . > > You have multiple triples that match > > ?x ss:row 1 pattern > > And you have multiple triples that match > > ?x ss:column ?y pattern > > You do not have any triples that match both. > > > If you think of your data as a graph and understand query as a graph pattern > matching process, this becomes quite clear. It helps to draw out the data in > a graph. > > The question goes back to understanding fundamentals of RDF graph data model. > It is hard (and I would not advise) to move to more complex topics of OWL and > SHACL (or even RDFS) until RDF is fully understood. > > In trainings, I typically spend significant time just on RDF, then followed > by SPARQL - because one can’t do SPARQL until they understand RDF. > Conversely, if they do understand RDF, SPARQL should be fairly easy. > > Only after that, it is possible to successfully move on and master other > topics. > > > > On Nov 20, 2019, at 8:56 AM, 'Bohms, H.M. (Michel)' via TopBraid Suite Users > <[email protected]> wrote: > > > That’s it 😊 thx. > Still trying to understand why...because they are “bound together”? > > > > > Dr. ir. H.M. (Michel) Böhms > Senior Data Scientist > > > T +31888663107 > M +31630381220 > E [email protected] > Location > > > <image001.gif> > 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. > > > > > Van: [email protected] <[email protected]> Namens > Richard Cyganiak > Verzonden: Wednesday, November 20, 2019 2:46 PM > Aan: topbraid-users list <[email protected]> > Onderwerp: Re: [topbraid-users] contsruct query question for sheets > > I think the OPTIONAL needs to surround all three lines: > > OPTIONAL { > ?unitCell ss:row 1 . > ?unitCell ss:column ?y . > ?unitCell ss:cellContents ?unit > } > > and same for the datatype. > > Richard > > > > > On 20 Nov 2019, at 13:34, 'Bohms, H.M. (Michel)' via TopBraid Suite Users > <[email protected]> wrote: > > Hmmmm > > > PREFIX ss: <http://www.topbraidcomposer.org/owl/2006/08/spreadsheets.owl#> > PREFIX bsc: <https://w3id.org/def/basicsemantics-owl-complex#> > CONSTRUCT { > ?uri a bsc:PropertyDef . > } > WHERE { > ?dataCell ss:row ?x . > ?dataCell ss:column ?y . > ?dataCell ss:cellContents ?dataValue . > ?propertyCell ss:row 0 . > ?propertyCell ss:column ?y . > ?propertyCell ss:cellContents ?property . > ?unitCell ss:row 1 . > ?unitCell ss:column ?y . > OPTIONAL { ?unitCell ss:cellContents ?unit } > ?datatypeCell ss:row 2 . > ?datatypeCell ss:column ?y . > OPTIONAL {?datatypeCell ss:cellContents ?datatype } > > BIND > (iri(concat("http://www.topbraidcomposer.org/owl/2006/08/spreadsheets.owl#",?property)) > AS ?uri ) > FILTER ( ?x > 2)} > > Gives me only instances for property names (first row, row 0) for which there > are units defined in second row 1. > I thought that putting optional there would give them all..... > Adding OPTIONAL also for the general ?dataCell ss:cellContents ?dataValue . > does not help > > Where is my thinking wrong? > > Thx Michel > > > > > > Dr. ir. H.M. (Michel) Böhms > Senior Data Scientist > > > > T +31888663107 > M +31630381220 > E [email protected] > Location > > > <image001.gif> > 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. > > > > > Van: [email protected] <[email protected]> Namens > Richard Cyganiak > Verzonden: Tuesday, November 19, 2019 10:11 AM > Aan: topbraid-users list <[email protected]> > CC: Bektas, K.E. (Esra) <[email protected]> > Onderwerp: Re: [topbraid-users] contsruct query question for sheets > > > > > > > On 19 Nov 2019, at 08:12, 'Bohms, H.M. (Michel)' via TopBraid Suite Users > <[email protected]> wrote: > > ?dataCell ss:row ?x > ?dataCell ss :column ?y. > ?dataCell ss:cellContents ?dataValue > ?propertyCell ss:row 1. > ?propertyCell ss :column ?y. > ?propertyCell ss:cellContents ?propertyValue > ?unitCell ss:row 1. > ?unitCell ss :column ?y. > ?unitCell ss:cellContents ?unitValue > ?datatypeCell ss:row 1. > ?datatypeCell ss :column ?y. > ?datatypeCell ss:cellContents ?datatypeValue > > FILTER (?x > 3) > > This looks good, except you need 1/2/3 for the three ss:row patterns instead > of the 1/1/1 you have there. > > Despite your hints I struggle with the actual construct part (instantiation > of the row-instances). > > Try doing a simple SELECT first, with this graph pattern instead of the ... > part: > > SELECT ?x ?propertyValue ?dataValue ?unitValue ?datatypeValue > WHERE { > ... > } > > Each result row should now have all the ingredients that you need to > construct one triple. > > The next step is to turn it into a CONSTRUCT: > > CONSTRUCT { > ?s ?p ?o > } > WHERE { > ... > BIND (subjectExpr AS ?s) > BIND (predicateExpr AS ?p) > BIND (objectExpr AS ?o) > } > > But the three xxxExpr parts still need to be replaced with real expressions > that create the appropriate RDF nodes. Something like: > > subjectExpr: IRI(CONCAT(STR(<http://example.com/item/>, STR(?x))) > predicateExpr: IRI(CONCAT(STR(<http://example.com/property/>, > STR(?propertyValue))) > objectExpr: STRDT(?dataValue, xsd:string) > > These should work as a starting point, but the real expressions are probably > going to be more complicated than that. The objectExpr will need to do > something appropriate with ?unitValue and ?datatypeValue. > > If the expressions become too complicated, it might be best to turn the > expressions into SPIN functions. That way, the complexity is contained in one > place, and the SPIN function can be re-used in other queries. > > If extra triples are needed in the output, like an rdf:type triple for each > subject, then it's probably easiest to make a separate query that produces > only those extra triples. > > Hope that helps, > Richard > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/9E0CA9F7-2D4D-4604-9164-4FD010B8866B%40topquadrant.com. > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/4d94a0d7d16948c7914f9c3ac03657cb%40tno.nl. > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/77F21491-7E6A-46A3-90EC-B9832883A709%40topquadrant.com. > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/97739fde12a94b4c9b92378a97b798af%40tno.nl. > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/B8E1107F-324D-414D-B628-12578963B6C7%40topquadrant.com. > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/114a9ef54ed04e1a9a977ea6b9a26c23%40tno.nl. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/D0B3C21B-09C9-4860-8538-6805DA2E6608%40topquadrant.com.
