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

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

shiguelita — Fri, 11 Sep 2015 14:38:16 GMT

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

ms — Fri, 11 Sep 2015 16:10:59 GMT

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 — Fri, 11 Sep 2015 17:04:39 GMT

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