Hi: I am novice to TBC and still in learning process. I am retreiveing
data from RDF files followed by sml:CreateSpreadsheet and
sml:ExportToTextFile.
In sml:CreateSpreadsheet I am using the following query.
SELECT *
WHERE {
?var prism:isPartOf ?isPartOf .
?var prism:publicationDate ?publicationDate .
?var prism:publicationName ?publicationName .
?var prism:publicationVolume ?publicationVolume .
?var dc:title ?title .
?var dcterms:abstract ?abstract .
?var dcterms:creator ?creator .
}
For every record(instance) there are 1-30 creators and while
retrieving the data except "creators" rest of the data is duplicating.
I believe in SQL Server we use CTE function for data like "creators"
to split in separate columns like (creator1, creator 2...creatorN). So
is there any function is TBC which I can use to do the same. If there
are no functions so can anyone please help me out with the query to
perform the same without duplicating values.
Please guide me in the above matter.
Thanks,
Vk
--
You received this message because you are subscribed to the Google Groups
"TopBraid Composer Users" group.
To post to this group, send email to topbraid-composer-us...@googlegroups.com.
To unsubscribe from this group, send email to
topbraid-composer-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/topbraid-composer-users?hl=en.
