I agree. What would this tool do with the following?
:s :p1 "label1a" .
:s :p1 "label1b" .
:s :p2 "label2" .
:s :p3 :s2 . :s2 p1 "label3"
For a somewhat animated version of this issue as I understand it, showing why
the ability to store data that doesn't fit well into tables is one of the great
advantages of RDF, see 2:38 - 3:04 of
https://www.youtube.com/watch?v=FvGndkpa4K0 .
Thanks,
Bob
On 4/22/21 5:45 AM, Martynas Jusevičius wrote:
OK, I think now I get a better idea of what you want to do.
It won't work in a general case because RDF resources can have
duplicate properties but CSV shouldn't have duplicate columns.
On Thu, Apr 22, 2021 at 11:41 AM Mikael Pesonen
<[email protected]> wrote:
I think that is for serializing the triplets as they are, in cleaner
format, but it doesn't say anything about rearranging the data.
On 22/04/2021 12.34, Martynas Jusevičius wrote:
This is probably what you want: https://www.w3.org/TR/sparql11-results-csv-tsv/
Try curl -H "Accept: text/csv" with SELECT results.
On Thu, Apr 22, 2021 at 11:30 AM Mikael Pesonen
<[email protected]> wrote:
Hi,
not exactly Jena related, but does anyone know if there is a tool or
sparql query that would read (almost) any kind of RDF data and make a
csv sheet where each column has predicates as headers and values as
cells. It would also be nice to get linked resources into the table the
same way. Even a hint how to make each predicate a new column in sparql
would be helpful.
So for example
:s :p1 "label1" .
:s :p2 "label2" .
:s :p3 :s2 . :s2 p1 "label3"
->
:p1 :p2 :p3/:p1
:s label2 label2 label3
Br,
Mikael
--
Lingsoft - 30 years of Leading Language Management
www.lingsoft.fi
Speech Applications - Language Management - Translation - Reader's and Writer's
Tools - Text Tools - E-books and M-books
Mikael Pesonen
System Engineer
e-mail: [email protected]
Tel. +358 2 279 3300
Time zone: GMT+2
Helsinki Office
Eteläranta 10
FI-00130 Helsinki
FINLAND
Turku Office
Kauppiaskatu 5 A
FI-20100 Turku
FINLAND
