Auto-generated import data script does not run

1 view (last 30 days)
Hi,
I'm using the import tool to import some data. The import tool works just fine, but the automated script it generates (attached) throws an error that seems to be related to its syntax:
"Undefined function or variable 'raw'.
Error in Untitled2 (line 38)
rawStringColumns = string(raw(:, [1,2,3,4,5,6,7,8,9,10,11,12,13,14]));"
Can you please check and tell me what may be going on?
Thx!

Accepted Answer

Ameer Hamza
Ameer Hamza on 21 May 2018
The file you attaches has a difference from the script file uiimport tool generate for automatically loading data from a general type of file. The file should have few lines before
numericData = NaN(size(dataArray{1},1),size(dataArray,2));
defining the raw variable. Are you sure you haven't accidentally deleted those lines? Try generating the script again.
  2 Comments
Fernando Tomasel
Fernando Tomasel on 21 May 2018
Edited: Walter Roberson on 21 May 2018
Thanks Ameer - I did generate the script again, but it came up exactly the same... however, prompted by your comment, I generated a script based on a second dataset, and that created the few extra lines I was missing:
raw = repmat({''},length(dataArray{1}),length(dataArray)-1);
for col=1:length(dataArray)-1
raw(1:length(dataArray{col}),col) = mat2cell(dataArray{col}, ones(length(dataArray{col}), 1));
end
The difference between the two datasets is that the first had tagged all columns with 'categorical' as data type, while the second set had one column tagged as 'text'. Somehow, the dataset that had all as categorical did not generate the extra lines of code.
Thanks!
Ameer Hamza
Ameer Hamza on 22 May 2018
That's true, I just tested and found this issue in R2017b that if all columns are categorical, these lines are skipped. This might some bug. R2018a produce a correct script file.

Sign in to comment.

More Answers (0)

Categories

Find more on Data Import and Export in Help Center and File Exchange

Products


Release

R2017b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!