topic Re: Data Table evaluation in For Loop from a list in Discussions

Data Table evaluation in For Loop from a list

user8421 — Sat, 10 Jun 2023 23:42:11 GMT

I keep running into an error with my script to rename data tables using a For loop.

Here's a simplified version of my script

OldNames = {"Old Name 1", "Old Name 2", "Old Name 3"};
NewNames = {"New Name 1", "New Name 2", "New Name 3"};

For( i, i <= NNames, i++,
    dt = Data Table( OldNames[i] );
    dt << Set Name( NewNames[i] );
);

I keep getting the following error

Cannot locate data table in access or evaluation of 'Data Table' , Data Table/*###*/( OldNames[i] )

However when I evaluate Data Table(OldNames[1]) there is no error!

Re: Data Table evaluation in For Loop from a list

HadleyMyers — Wed, 05 Jan 2022 08:37:06 GMT

Hi,

I changed the first two arguments of the For loop accordingly. It should work now:

OldNames = {"Old Name 1", "Old Name 2", "Old Name 3"};
NewNames = {"New Name 1", "New Name 2", "New Name 3"};

For(
     i=1,

     i <= NItems(NewNames),

     i++,

     dt = Data Table(OldNames[i]);

     dt << Set Name(NewNames[i])

);

Re: Data Table evaluation in For Loop from a list

jthi — Wed, 05 Jan 2022 08:37:51 GMT

You seem to be missing at least definition for i (i = 1), also I'm not sure what NNames is.

This should be working example:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt = Open("$SAMPLE_DATA/Quality Control/Failures3Delimited.jmp");
dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");

OldNames = {"Big Class", "Failures3Delimited", "Semiconductor Capability"};
NewNames = {"New Name 1", "New Name 2", "New Name 3"};

For(i = 1, i <= N Items(OldNames), i++,
	dt = Data Table(OldNames[i]);
	dt << Set Name(NewNames[i])
);

Re: Data Table evaluation in For Loop from a list

user8421 — Wed, 05 Jan 2022 22:19:41 GMT

Sorry I realized I did miss the parts of my script while I was simplifying.

NNames = NItems(NewNames);
and i=1 for the first argument in the For loop.

Even with both of those defined correctly in my script I still get the same error message

Re: Data Table evaluation in For Loop from a list

gzmorgan0 — Fri, 07 Jan 2022 06:42:14 GMT

@user8421 ,

Did you successfully run @jthi's script? If yes, then I suspect:

one or more of the tables are closed
one or more of the tables are private
wrong old names.

Below is a slight modification to @jthi's script. I make the 3rd table private, and I add show statements to the For loop.

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt = Open("$SAMPLE_DATA/Quality Control/Failures3Delimited.jmp");
dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp", "Private");
OldNames = {"Big Class", "Failures3Delimited", "Semiconductor Capability"};
NewNames = {"New Name 1", "New Name 2", "New Name 3"};


For(i = 1, i <= N Items(OldNames), i++,
    show(i, OldNames[i], NewNames[i]);
	dt = Data Table(OldNames[i]);
	dt << Set Name(NewNames[i]);
);

Here is the log output

/*:

i = 1;
OldNames[i] = "Big Class";
NewNames[i] = "New Name 1";
i = 2;
OldNames[i] = "Failures3Delimited";
NewNames[i] = "New Name 2";
i = 3;
OldNames[i] = "Semiconductor Capability";
NewNames[i] = "New Name 3";
Cannot locate data table in access or evaluation of 'Data Table' , Data Table/*###*/(OldNames[i])

at line 11 in Script.jsl

The JMP Scripting Guide states for private table that

Private tables are not counted when N Table() returns the number of open data tables.
Private tables cannot be made current with Current Data Table().

This made me think that a private table might not have the same functionality, might not have teh names stored in memory since it is not counted.

Good luck!

Re: Data Table evaluation in For Loop from a list

user8421 — Thu, 20 Jan 2022 04:00:11 GMT

Thanks a bunch. It was an issue with one of the table names and one tables being a private table.