Subscribe Bookmark RSS Feed

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

shiguelita

Community Trekker

Joined:

May 27, 2015

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
Solution

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"));

2 REPLIES
Solution

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

Community Trekker

Joined:

May 27, 2015

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