Multivariate - error loading datasets

I cannot get the multivariate analysis (PCA) to work.
The error message is:
Error: Variable names (or number) in the data matrix (first column) and sample metadata (first column) are not identical; use the ‘Check Format’ module in the ‘Quality Control’ section
Execution halted

I was very careful in matching the sample names in the sample metadata with those in the data matrix.

This is my history:

Thanks your help and advise
Peter-Bram

Hi @pacthoen

Thanks for sharing the history! I can see that you’ve run some checks on the files to confirm the formats. I’m wondering if using a 0 as the leading header value is causing the problem (technical wrinkle). And there could be something else super minor too.

The Check Format tool is really good, and can make small adjustments for you at runtime, so you might as well toggle that on!

I have a shared history here with an example. Notice how I ran the tool, then compared the before and after results to investigate exactly what was different/changed in an HTML table.

Would you like to give that a try? Then let us know if it was enough or if you need more help. Please make sure I can see that tool’s output in your shared history (go back into the Share or Publish view and toggle it off/on). Thanks! :slight_smile:

Dear Jennifer
Thank you for the quick reply and the tip. The check data formats tool worked very well because it now appeared that the length of the variables in the variable table were not consistent with the variables in the data matrix.
Best
Peter-Bram

1 Like

Great, I’m glad that worked! I wish all software packages included a tool like that one! :hammer_and_wrench: