Hi all,
I am working on importing various structured data files into a jmp dataframe using the Open method. I am struggling to see what I am doing wrong for the second case as I am able to use the method to subset as I wish for the first code block. Any help would be appreciated!
[file name] is for the string format of the file name not a variable reference. I am omitting full name per company policy.
Working Subset using Select Columns:
sl = Open(Pick File()/"[file name].xls",
Select Columns ("Description", "Sample Mix", "Analyte Type", :Name("Threshold (nA)"), "Expected Outcome", "Lane", "Heater")
) << Set Name ("Sample Lookup");Not Working Subset (Getting all original columns returned):
sd = Open (Pick File()/"[file name].csv",
Select Columns ("Accession Number", "Pad Name", " Warnings")
) << Set Name("Signal Data");Only thing I can think of why the bottom case does not subset based on columns is the different data formats of xls vs csv. But if this is the case how would I go about correcting this? Thank you!
