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. 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. 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. Regards, Irene Polikoff From: [email protected] [mailto:[email protected]] On Behalf Of Bo Ferri Sent: Thursday, July 11, 2013 3:57 PM To: [email protected] 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] 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. -- -- 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.
