topic Re: new column with initial data values in Discussions

new column with initial data values

MTOF — Tue, 18 Oct 2011 12:54:53 GMT

Does anyone know how to script the creation of a new column with initial data values?

Below is my best guess, but it doesn't work. Cannot find any help on "initial data values" in the scripting guide.

BR, Marianne

dt=current data table();

dt<<new column("Selected", character, initial data values(constant("YES")));

new column with initial data values

pmroz — Tue, 18 Oct 2011 13:54:09 GMT

You're close. This will work:

dt=current data table();

dt << new column("Selected", character, << set each value("YES"));

new column with initial data values

MTOF — Tue, 01 Nov 2011 20:47:42 GMT

Excellent, just what I needed

Re: new column with initial data values

JMP_Learner — Fri, 16 Jun 2017 21:56:40 GMT

Hi!

I have a similar but a little more complicated problem:

The initial value I try to set is a function of loop index.

Suppose I have 50 files to open. When open each file, I want to add a new column, and fill the new column with the file name of this file. The initial value is supposed to be a constant. But, when this function is used within a loop, the code seems stuck. It opens the first file, without filling the initial value, and stopped.

How should I make it work?

Thanks a lot.

Re: new column with initial data values

ian_jmp — Mon, 19 Jun 2017 09:30:06 GMT

Maybe something like this?

NamesDefaultToHere(1);

// Make some tables, save and close them, but keep a list
n = 4;
fList = {};
for(t=1, t<=n, t++,
	fName = "Table "||Char(t)||".jmp";
	dt = NewTable(fName, NewColumn("Data", Formula(RandomInteger(10))));
	dt << AddRows(20);
	InsertInto(fList, fName);
	Close(dt, Save("$DESKTOP/"||fName));
);

// Open the tables in the list and add the column
for(t=1, t<=NItems(fList), t++,
	fName = fList[t];
	dt = Open("$DESKTOP/"||fName);
	colVals = {};
	for(r=1, r<=NRow(dt), r++,
		InsertInto(colVals, fName);
	);
	dt << NewColumn("File Name", Character, Values(colVals));
	DeleteFile("$DESKTOP/"||fName);
);

Re: new column with initial data values

JMP_Learner — Mon, 19 Jun 2017 17:07:54 GMT

Ian_jmp:

Your idea works great! Thank you so much!

JMP_Learner

Re: new column with initial data values

hogi — Thu, 15 Aug 2024 18:09:07 GMT

https://community.jmp.com/t5/Discussions/Initialize-data-very-useful-but-fragile/m-p/780753