Text to datastore error
2 views (last 30 days)
Show older comments
I'm getting the following error when using text to datastore
Error using matlab.io.datastore.TabularTextDatastore/set.SelectedVariableNames (line 619) SelectedVariableNames must be a unique subset of VariableNames.
Was hoping omeone could explain what this could possibly mean? I've gone through all the data and it is there in the correct format, all the headings appear to be spelt the same, and i'm pretty confident my variable names are correct. Any light on the potential would be good
2 Comments
Nicole Peltier
on 23 Sep 2018
Without seeing the data, my guess is that you're trying to reuse a variable name within a table. Could you share your table so we can get a better idea of what's happening?
Answers (1)
GioPapas81
on 30 Sep 2019
Hi,
I am also getting the same error when I do the following:
ds.SelectedVariableNames = {'eid','20201-2.0'};
Error using matlab.io.datastore.TabularTextDatastore/set.SelectedVariableNames (line 619)
SelectedVariableNames must be a unique subset of VariableNames.
I don't have other variable with that name, but the same name repeats in the same column across multiple rows.
I am attaching my .csv file.
Any help would be great.
Thank you.
1 Comment
Al Dente
on 30 Sep 2019
Edited: Al Dente
on 30 Sep 2019
ds.SelectedVariableNames = {'eid','20201-2.0'};
in this example '20201-2.0' is not a valid variable name:
"Starting in R2019b, variable names and row names can include any characters, including spaces and non-ASCII characters. Also, they can start with any characters, not just letters. Variable and row names do not have to be valid MATLAB identifiers (as determined by the isvarname function). To preserve these variable names and row names, set PreserveVariableNames to true."
if you don't have 2019b then this is probably the problem, however if you do then: "To support invalid MATLAB identifiers as variable names, such as varible names containing spaces and non-ASCII characters, set the PreserveVariableNames parameter to true."
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!