topic Re: What are the data table names after multiple file import? in Discussions

What are the data table names after multiple file import?

TDK_Long — Thu, 08 Jun 2023 16:28:13 GMT

Hi folks,

I used multiple file import to import three txt files, and the script opened up three data windows shown on the right hand side. I need to process the column 3 with some equations in these three opened windows, but I don't know the data table names that are related to the three opened windows.

I thought the data table names should be ccf_22031411, ccf_22031412 and ccf_22031413 as shown on the top left corner of the data windows, but when I used the following script to delete the first column (dot column), it did not work. And how can I call out Column 3 and make it multiplied by 10 and put the new numbers into Column 7? Thanks.

"ccf_22031411" << delete Columns( 1 :: 1 );

Re: What are the data table names after multiple file import?

Craige_Hales — Thu, 16 Mar 2023 02:10:23 GMT

dtList contains a list of three data table handles. You could use the handles directly and never need to know the name. You could ask the handle for the name of the table. Or you could use the handle to set a name.

show(dtList);
dt1=dtList[1];
show(dt1<<getname);
dtList[2]<<setname("xyzzy");
show(dtlist[2]<<getname);
dtList[3]:column1<<setname("plugh");
show(column(dtList[3],1)<<getname);

Above, dt1 copies the handle from the list to simplify the next reference. The rest just use the handle directly from the list.

Re: What are the data table names after multiple file import?

TDK_Long — Thu, 16 Mar 2023 23:42:23 GMT

Thanks Craige. You have helped me a lot of times.