topic Re: Rename Data Table Script in Discussions

Rename Data Table Script

Aam_jmp — Mon, 07 May 2018 13:58:10 GMT

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

Re: Rename Data Table Script

uday_guntupalli — Mon, 07 May 2018 13:34:11 GMT

@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.

Re: Rename Data Table Script

Aam_jmp — Mon, 07 May 2018 13:42:10 GMT

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?

Re: Rename Data Table Script

uday_guntupalli — Mon, 07 May 2018 13:59:05 GMT

@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.

Re: Rename Data Table Script

Aam_jmp — Mon, 07 May 2018 14:11:12 GMT

Thank you very much