Pasting in data when column data types are different

jennifer_n_blak

Hello!

  I am trying to paste into a preexisting data table an updated row of data from excel.  The problem is, I've been working with the data already in JMP for several days and made changes to column properties, etc.  Now, even though the old and new data will line up perfectly by column, I continue to get an error message from JMP, saying that "Data types of destination columns and source columns are different."

 

How do I override this and coerce the data types in the new row to the old format?

 

Thank you for your help!

Jennifer

 

P.S.

I've already tried these tactics:

pasting directly from excel

creating a new data table in JMP and then pasting from there

 

Although I could concatenate this in, I think there must be a simpler way! Cut and paste is early 90s technology...

txnelson

Your issue is undoubtedly that the one or more of the JMP columns you are attempting to copy into are numeric, and the data you are attemping to paste into that column are not numeric in form, or at least JMP does not think it is.  Without seeing an example of the data in question, I can only guess at a solution.  

Many times, if you are attempting to paste in a Time or Date value, and you can have a conflict if in Excel, the values are in a text string, and in JMP you have them in a numeric Date/Time structure.  You can fix this copy/paste issue, by changing the "Informat" in JMP to expect the data in the text format specified in Excel.

If the data are invalid-to-JMP values, you will have to copy them into a new data table, then change the column data types, and then either do a concatinate or an Update to put the data together.