Mapping (CSV input)

Stardog Designer
1

Hi, I am having difficulties understanding how the mappings feature works in Designer.
I have a very simple model:

Screen Shot 2022-05-12 at 15.16.48
Screen Shot 2022-05-12 at 15.16.481368×1334 73.3 KB

The Mapping screen in Designer looks like this;

Screen Shot 2022-05-12 at 15.17.44
Screen Shot 2022-05-12 at 15.17.441414×988 131 KB

When I view one of the (top) Categories:

Screen Shot 2022-05-12 at 15.11.30
Screen Shot 2022-05-12 at 15.11.301220×536 73.6 KB

You can see the subcategories include the "Cosmetic_Category" string.
It seems like I also need to specify that the column called "Subcategory" are also of type "Cosmetic Category" ?

Any help welcome :slight_smile:

Cheers - Renato

2

Hi Renato,
Yes, that's correct that you'd need an additional mapping from your table to the Cosmetic Category node class, to indicate that SubCategory is also a Primary Identifier. We don't yet support parallel mappings between a data source and the same node class.

You should be able to achieve this by uploading the category CSV twice, and map the copy to Cosmetic Category with SubCategory as the primary identifier and SubCategoryLabel as the label. Alternatively, you could modify your CSV to look more like:

| Category | CategoryLabel | SubCategory |
|----------|---------------|-------------|
| skin     | Skin          | cream       |
| skin     | Skin          | oil         |
| ...      |               |             |
| cream    | Cream         |             |
| oil      | Oil           |             |
3

Great...many Thanks
(some chars to bypass 20 :slight_smile: