topic How to import already created validation column in JMP? in Discussions

How to import already created validation column in JMP?

abhinavsharma91 — Sat, 10 Jun 2023 23:58:03 GMT

I have a dataset in which training and validation data points are already defined. First N rows are training data and remaining are validation data. Data set in Excel file.

Now, how to use already created validation column (in Excel) while performing some analysis in JMP (e.g. neural nets).

Re: How to import already created validation column in JMP?

txnelson — Fri, 09 Dec 2022 15:39:54 GMT

JMP wants a column called Validation that contains the values "Training" or "Validation". Therefore, all you need to do is to pass such a structure to JMP from Excel, or after creating the JMP table, create a new Validation column, and to apply a simple formula to set the values in the column based upon the Excel column you are passing.