Mike; When doing your transform to nstances, use SELECT DISTINCT.
E.g. assuming your column property for colour is :colour:
SELECT DISTINCT ?colour
WHERE
{ ?subj :colour ?colour
}
-- Scott
On Sep 26, 12:41 am, Mikey <[email protected]> wrote:
> I am trying to import a regular excel sheet and then manipulate the
> contents with the ApplyConstruct node.
>
> But I'm finding it difficult to form the right SPARQL to do the job.
>
> For example.
>
> If I have the following excel data:
> Product Colour Size
> P1 Blue Large
> P2 Red Large
> P3 Blue Small
> P4 Red Small
>
> I want to end up with 3 classes and 8 instances, namely:
> Product (P1,P2,P3,P4) Colour(Red,Blue) and Size (Large, Small)
> With assertions
> P1 hasColour Blue
> P1 hasSize Large
> ...
>
> When I run my SPARQL, I end up with 4 instances of Colour
> (Blue,Red,Blue,Red) and 4 instances of Size (Large,Large,Small,Small)
>
> How do I express that Cells in Column 1 with the same CellContents are
> the same thing?
>
> Mike.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TopBraid Composer Users" group.
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-composer-users?hl=en
-~----------~----~----~----~------~----~------~--~---
