topic Re: How do I copy and paste a formula in Discussions

How do I copy and paste a formula

ExpectedLlama88 — Wed, 08 May 2024 20:52:42 GMT

I am using

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

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

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

Re: How do I copy and paste a formula

txnelson — Wed, 08 May 2024 21:40:59 GMT

Right click on the Column Header and select

Copy Column Properties

Then go to the column you want the formula copied to and right click on it's header and select

Paste Column Properties.

From the Formula Editor, you can also double click on a blank space in the formula

and the formula will be displayed as simple text (JSL)

Then you can highlight the text and copy it to the paste buffer,

Then go to the new columns Formula Editor and past the formula into it

Re: How do I copy and paste a formula

ExpectedLlama88 — Wed, 08 May 2024 22:04:39 GMT

Thanks. Unfortunately when I attempt to paste the column properties from the old data set to the new data set I get the following error message:

Re: How do I copy and paste a formula

stan_koprowski — Wed, 08 May 2024 22:20:12 GMT

Hi @ExpectedLlama88,

Check the column data types- in the first table the variable is character and in the other table the variable is numeric.

The formula would need to be modified or the column data type in the second table would need to be updated to match.

cheers,

Stan

Re: How do I copy and paste a formula

ExpectedLlama88 — Wed, 08 May 2024 23:22:11 GMT

Still no joy. Here is a screen shot of the properties for the column of interest in the old data set:

This is a screen shot of the properties for the column of interest in the new data set:

Re: How do I copy and paste a formula

stan_koprowski — Wed, 08 May 2024 23:44:16 GMT

Hi,

Update the column name in the incidents table from “Day” to “Day of Week”.

The choose function is expecting the column name for its first argument to be “Day of Week” as shown in the formula editor of your screenshot.

cheers,

Stan

Re: How do I copy and paste a formula

ExpectedLlama88 — Thu, 09 May 2024 00:52:18 GMT

When trying to paste column properties from column 9 of the old data set to column 9 of the new data set I get the following error:

I've been using the formula in question every month this year pasting it into each new data set in the appropriate row without a problem. However in trying to do this for the YTD incident report for the month of April 2024, nothing seems to work. Given that knowledge of statistical analysis is limited to a couple of courses I took at UNI over 30 years ago, at best I know enough to be a useful idiot.

Re: How do I copy and paste a formula

stan_koprowski — Thu, 09 May 2024 01:48:34 GMT

Hi @ExpectedLlama88 ,

If possible can you share anonymized versions of your data tables or mocked up examples of each table with a few rows of data ( with the formula columns ) and we can continue to trying to resolve the issue you are facing.

cheers,

Stan

Re: How do I copy and paste a formula

jthi — Thu, 09 May 2024 06:34:52 GMT

Informat() function only works for characters.

Just based on your visible columns I guess that in first table Day column is character (JMP won't tell it to us (still waiting for more icons to be implemented...), but it is nominal + formula works -> character column) and next one has numeric column (we can see it is continuous -> numeric).

If this isn't the case, then we will most likely need some sort of small example of your datasets like @stan_koprowski said.

Re: How do I copy and paste a formula

ExpectedLlama88 — Mon, 13 May 2024 20:36:33 GMT

Thanks all for trying to help me out with this. Unfortunately no joy and I ran out of time to try and find a solution. I ended up applying a simple work around that solved my problem. However the orginal issue remains.

Re: How do I copy and paste a formula

hogi — Mon, 13 May 2024 21:25:33 GMT

issues and explanations:

you tried to paste the formula into column "Day". this leads to a loop day = f(day) - and the evaluation is interrupted.
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

Re: How do I copy and paste a formula

hogi — Mon, 13 May 2024 21:28:56 GMT

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

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