cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
shiguelita
Level I

How Can I use script to create a new table with Concatenate?

Hey guys,

I'm beginner in JMP's scritp and I want to know how I can use script to create a new table using Concatenate.

My script is:

dt =  Open( "C:\EKS\ETAMS\concat1.jmp");

dt << Set Name ("conc1");

dt =  Open( "C:\EKS\ETAMS\concat2.jmp");

dt << Set Name ("conc2");

dt << Concatenate("conc1", Output Table( "Combined" ));

But it's just opening the Concatenate window, it doesn't create a new table. What Am I doing wrong?

Please, help me! =(

Regards

Talita Shiguemoto

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How Can I use script to create a new table with Concatenate?

You're almost there! Assign the two tables to two different variables. There is no need to rename the tables.

dt1 = Open("C:\EKS\ETAMS\concat1.jmp");

dt2 = Open("C:\EKS\ETAMS\concat2.jmp");

dt2 << Concatenate(dt1, Output Table("Combined"));

View solution in original post

2 REPLIES 2
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How Can I use script to create a new table with Concatenate?

You're almost there! Assign the two tables to two different variables. There is no need to rename the tables.

dt1 = Open("C:\EKS\ETAMS\concat1.jmp");

dt2 = Open("C:\EKS\ETAMS\concat2.jmp");

dt2 << Concatenate(dt1, Output Table("Combined"));

shiguelita
Level I

Re: How Can I use script to create a new table with Concatenate?

Hey MS, thank you very much. It worked! *_*