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
-~----------~----~----~----~------~----~------~--~---

Reply via email to