How to import already created validation column in JMP?

[#1]

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).

[#2]

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.