Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Determine Unique Identifiers More Easily #1387

Open
tboeni opened this issue Mar 6, 2023 · 1 comment
Open

Determine Unique Identifiers More Easily #1387

tboeni opened this issue Mar 6, 2023 · 1 comment
Labels
UX User experience issue

Comments

@tboeni
Copy link

tboeni commented Mar 6, 2023

This feature request is rather a question of possibility:
Recently I am dealing with file with a rather large number of differenct column names and row counts. This makes choosing the identifier quite a lot more difficult in my opinion.
Cube Creator does give a warning message if the observation identifiers are not unique and this made me wonder.

Is there a way to maybe give a reference to the row/line number where the identifiers are not unique?
This would make the process of fixing the issue a low easier but I am also not aware how Cube Creator is able to determine the non-uniqueness of the identifiers, so I might be completely on a wrong track here.

@tpluscode tpluscode added the UX User experience issue label Mar 6, 2023
@tpluscode
Copy link
Collaborator

That is an interesting idea.

[...] how Cube Creator is able to determine the non-uniqueness of the identifiers

By definition, every observation must have exactly one value for each of its dimensions. When an identifier is not unique, some observations will end up merged together, and thus having multiple values for properites. Cube Creator runs a query over the transformed data

Unfortunately, at the moment there is no SPARQL UI for cube creator's database. It would have been easiest to link to that precise query.

@dabo505 dabo505 removed their assignment Jun 15, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
UX User experience issue
Projects
Status: Needs triage
Development

No branches or pull requests

3 participants