cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar

How do I copy and paste a formula

I am using 

ExpectedLlama88_2-1715197788665.png

I am trying to paste the following formula from one data table to another (similar) table:

ExpectedLlama88_0-1715197582318.png

However when I paste it into the new table I get an error message and the formula will not work

ExpectedLlama88_1-1715197679259.png

How do I resolve this so that the formula will operate properly?  Thanks

11 REPLIES 11
hogi
Level XIII

Re: How do I copy and paste a formula

issues and explanations:

 

  • hogi_0-1715635302682.png
    you tried to paste the formula into column "Day". this leads to a loop day = f(day) - and the evaluation is interrupted.
  • hogi_1-1715635392621.png

    you renamed the input column day -> "Day of week"
    no column "day" -> formula complains

  • Character vs. Number issue.
    your original formula need "day" as Character, but in the new table "day" is a number
    --> open the column properties and change the data type from numeric to character

 

hogi
Level XIII

Re: How do I copy and paste a formula

But as "Day" is numeric in your new table, the easiest solution is:
right click on the column header and go to New Formula Column / Date Time / Day of Week Name

hogi_2-1715635607413.png

Then Jmp will generate a new column Day of Week[Day]

Recommended Articles