Same script does not work in new data table

[#1]

I am re-doing an analysis to make sure I have the process correct (currently using JMP Pro 17).  

In the first round, I imported a .xlsx file, saved it as a .jmp file, and then ran a script to format the variables.  Then, I successfully ran a second script.  No issues here; everything ran great.

For the second round, I took the same .xlsx file (with a different file name), imported it and saved it as a .jmp file.  Then, I copied the first script from the original .jmp file to the new .jmp file - and it ran fine.  Then, I took the second script from the original .jmp file, and copied it to the new .jmp file.  It ran (no errors), but gave me no data in the generated table.

As an additional attempt, I copied the contents of the original script into the new script, but that did not work either.

Any help figuring this out is greatly appreciated!

Best,

Kevin

[#2]

Are there any messages in the JMP Log?

[#3]

Thanks for your reply.  No, there were no messages in the JMP log. I have attached a snip.

The new file ran (creates a new table, but that table is blank).  The log shows that I opened this ww35 file, but has no other entry.  I opened the older ww28 file and the script ran fine (I stop the table generation a 1049761 rows).

Kevin

[#4]

Would it be possible for you to share the script you are running?

[#5]

Can you provide the scripts? And possibly data to repeat the issue. There could be names used as references for example in the script which could cause issues when running the script on differently named table. You could also try repeating your process using JMP Workflow (I think it was released in JMP17...). It can handle some of the possible changes

[#6]

Jarmo,

It has some sensitive information in it; so, let me see if I can change up the data table entries a bit and send out the generic file.  Thank you,

Kevin

[#7 · Accepted solution]

Ah, it seems that I had some non-blank rows at the bottom of my second data table.  Not sure why that was the case, but I removed them - and it worked.  Please see snip below.

Thank you very much for your willingness to help!

Best,

Kevin