cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Aam_jmp
Level IV

Rename Data Table Script

I know I can rename a data data table script using dt << Rename Table Script("Old","New"); But I want to rename more than one scripts and I am trying to rename all the scripts starting from the third script in the data table with the column names I acquired from a different table. Can anyone point me out to my mistake since I am getting no error in my log. Thank you. 

 

 

a1 = dt << getTableScriptNames;
show(a1);
names = dt1 << get column names(String);
 
for( i=3, i <= N Items( a1 ), i++,
dt << Rename Table Script(a1,Name);
show(a1);
);

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
uday_guntupalli
Level VIII

Re: Rename Data Table Script

@Aam_jmp,
        A couple of things, you will need to index into the list of names , not use the list as a whole. 

for(i = 3, i <= N Items(a1), i++,
		dt << Rename Table Script(a1[i],Names[i]); 
   );

 

      Another thing, I would keep in mind is if you are starting from i = 3, Are you sure you want to be naming starting from the 3rd column of dt1 - if yes, the above should work.  

Best
Uday

View solution in original post

4 REPLIES 4
uday_guntupalli
Level VIII

Re: Rename Data Table Script

@Aam_jmp,
        A couple of things, you will need to index into the list of names , not use the list as a whole. 

for(i = 3, i <= N Items(a1), i++,
		dt << Rename Table Script(a1[i],Names[i]); 
   );

 

      Another thing, I would keep in mind is if you are starting from i = 3, Are you sure you want to be naming starting from the 3rd column of dt1 - if yes, the above should work.  

Best
Uday
Aam_jmp
Level IV

Re: Rename Data Table Script

Thanks for the quick response. @uday_guntupalli I realized I missed out on indexing. I want to rename the table scripts beginning the third script, taking the first column name i.e. a[3] = Name[1]. How can I do that?

uday_guntupalli
Level VIII

Re: Rename Data Table Script

@Aam_jmp
     Simplest way I can think of is: 

for(i = 3, i <= N Items(a1), i++,
		dt << Rename Table Script(a1[i],Names[i-2]); 
   );

   However, irrespective of the approach you will need to ensure that as there are sufficient items in Names for you to do this. 

Best
Uday
Aam_jmp
Level IV

Re: Rename Data Table Script

Thank you very much

Recommended Articles