Re: [topbraid-users] Re: SPARQLMotion Distinct

[Scott Henninger]

Mark, have you looked into SPINMap?  This is really a nice way to perform transforms from one data format to another.  Very useful for spreadsheets in particular.  I think you will find this help file useful:    Help > Application Development Tools > SPIN > Ontology Mapping with SPINMap -- Scott On 10/4/2012 12:03 AM, Mark Colquhoun wrote: Hi Irene, Thanks for the detailed response. I did mention that I was reading from an Excel spreadsheet but it was probably hidden deep in a previous post. Based on the example I gave, I am reading data from a spreadsheet, performing a substring operation on one of the columns. From there, I need to identify the distinct values from this operation and create a new type of thing by constructing new triples where the distinct value is used to build the subject URI for the new triples. I have been using SM for a while and now and have had reasonable success however this problem has got me stumped probably because it requires me to use a new feature that I haven't previously used. Regards, Mark. On Thu, Oct 4, 2012 at 2:20 PM, Irene Polikoff <ir...@topquadrant.com> wrote: To add to Scott's reply, pretty much every SM module does one of the following: 1. Adds more triples into the pipeline (e.g., modules that import (load) RDF files or files that are auto-converted to RDF such as XML) 2. Establishes connection to external sources of triples (e.g., modules that connect to RDF databases, they are call "import" as well, but they just establish connection, they don't actually add triples from the external source into the pipeline) 3. Performs some processing based on triples that are passed to them as an input a) through the pipeline or b) from an external source (e.g, module that converts RDF to XML) 4. Does both 1 and 3 (e.g., inferencing modules or perform SPARQL update module) 5. Controls the processing (e.g., iterate over select) 6. Exports the results (e.g, all the "return" modules) Thus, a question to ask is what do you want to happen as a result of the select query? Depending on the answer, you may or may not need to run the select. Are you trying to return some RDF as a web service, for example? Then you don't really need the select query. Instead, you get to the point where the pipeline contains only the triples you want to return and the return module would return all of them. If you do need a select query and want to see modules that have it as a parameter, open your script, navigate to sml:selectQuery and see all the places it is referenced. Regards, Irene -----Original Message----- From: topbraid-users@googlegroups.com [mailto:topbraid-users@googlegroups.com] On Behalf Of Scott Henninger Sent: Wednesday, October 03, 2012 6:06 PM To: TopBraid Suite Users Subject: [topbraid-users] Re: SPARQLMotion Distinct Mark; Most SPARQLMotion modules include a query property.  Some examples - that you can download - are found at http://www.topquadrant.com/products/SPARQLMotion_docs/SPARQLMotion_ex_dbpedi aCapitals.html. I'd also suggest spending some time with the SPARQLMotion home page (http://www.topquadrant.com/products/SPARQLMotion.html) and the Getting Started Guide, Tutorial, and Videos provided on that page. Beyond that, if you have a more specific place you were looking to "use in a SPARQLMotion script to perform a SELECT query", let us know.  A hint: IterateOverSelect is needed less often than one would initially believe because SPARQL's declarative nature take care of iteratively finding results. -- Scott On Oct 3, 3:02 pm, Mark Colquhoun <mark.colquh...@codepoint.com.au> wrote: > Hi Scott, > > Yes that will work but I guess I'm missing something as I couldn't see > which module I could use in a SPARQLMotion script to perform a SELECT query > apart from an Iterate Over Select? > > Regards, > Mark. > > > > > > > > On Thursday, October 4, 2012 12:11:28 AM UTC+10, Scott Henninger wrote: > > > Will SELECT DISTINCT ?substr work?  If not, we will need more > > information on what your queries and script look like, etc. > > > -- Scott > > > On Oct 2, 11:50 pm, Mark Colquhoun <mark.colquh...@codepoint.com.au> > > wrote: > > > Hi, > > > > Within a SPARQLMotion script, I need to read a spreadsheet and find the > > > distinct values in a column based on a substring performed on the > > column. I > > > can do all of this except the distinct part and am looking for some > > > pointers. An example of the data might be: > > > > AI4120_0306_cH > > > AI4120_0306_cHH > > > AIC4120_0042_cSP > > > AIC4120_0042_sCV > > > > From these values, I want to create a substring including everything to > > the > > > left of the last _. > > > > AI4120_0306 > > > AI4120_0306 > > > AIC4120_0042 > > > AIC4120_0042 > > > > Easy enough so far but from here I want to select the distinct values. > > I'm > > > sure this should be easy but I haven't been able to find any build in > > > functionality to achieve this. The end result that am after should look > > > like: > > > > AI4120_0306 > > > AIC4120_0042 > > > > I'm sure there is something that I am overlooking so any help would be > > > greatly appreciated. > > > > Regards, > > > Mark. -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en     -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en