Hi Irene, thanks a lot for your fast response.
On Friday, July 12, 2013 3:32:57 AM UTC+2, Irene Polikoff wrote: > > Hi Bo, > > > > For number 3, you can construct only the triples you want (those that > match the criteria in the WHERE clause) and then have ‘replace = true’ > option on the constructing step. > So, does this mean that I cannot work with a BindOnSelect or IterateOnSelect component and utilise the variables of the selection instead of re-construction the triples that are affected? - i.e. I always need to construct the triple set that I would like to work on in the next step? > This will result in it passing to the next step only the triples that have > been constructed. But I am not sure I understand number 4. > Yes, number 4 is probably the "most complex" part in this pipeline. So far, I can imagine that I can fetch the relevant filter terms from the filter list with a sub query and apply them on a FILTER clause that will be applied on a substring function of the string value (one result variable from the previous step) in the upper SPARQL query, i.e., if the substring matches one of the filter terms, then the string value should be manipulated - otherwise not. > If you are not able to figure this out, you may want to send us small > sample files and define specifically the kind of selection and replacement > you need to do. > I need to figure this out, whether this is possible. Thanks a lot in advance. Bo > Regards, > > > > Irene Polikoff > > > > *From:* [email protected] <javascript:> [mailto: > [email protected] <javascript:>] *On Behalf Of *Bo Ferri > *Sent:* Thursday, July 11, 2013 3:57 PM > *To:* [email protected] <javascript:> > *Subject:* [topbraid-users] SPARQLMotion as proper ETL/data > transformation tool > > > > Hi, > > I'm experimenting a bit with SPARQLMotion (inside TBC ME) to do some > "proper" ETL/data transformation steps. I couldn't manage it yet to model > the following use case completely: > > 1. Load an source file (Turtle) > 2. Load another source file (Turtle), whose content should act as a kind > of filter list > 3. Define a filter view (selection) on data from the first file > 4. Match a string valu of this selection against the values of filter > list, i.e., if the string value contains on of the values of the filter > list values, then it matches > 5. Replace the string value on a match > 6. write these replacements to the model > > So far I can do the first 3 steps. However, I'm struggling a bit with the > middle part ;) > > Furthermore, is it possible to utilise the SPARQLMotion script engine also > in a larger (scalable) environment, i.e., a processing engine that works on > multiple machines etc.? So can I utilise SPARQLMotion scripts such as one > can deploy Talend jobscripts for example? > > Cheers, > > > Bo > > -- > -- 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 > [email protected] <javascript:> > To unsubscribe from this group, send email to > [email protected] <javascript:> > 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 Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- -- 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
