Reference portion of array/list indirectly

GreenisBTFL — Mon, 17 Jun 2024 15:59:42 GMT

Using JMP 17.0.0, Windows 10.

I've been unsuccessful at finding documentation on what I want to do, and it seems not to be as easy as I thought it would be...

What I want is to update a table (dtJ) with columns from another table (dtN), but not define precisely how many columns to add, as the amount of columns to be added may differ each time my For loop runs.

For( r = 1, r <= N Items( dtlist ), r++,
	dtN = Open( myPath || mySiteanalysis || dtlist[r] || myFilepost );
	dtNnames = dtN << Get Column Names ();
	dtNnamesv = N Items(dtNnames);

	dtJ << Update(
		With( dtN ),
		Match Columns( dtJ:dtJnames(r+13) = dtN:dtNnames(1) ),
		Add Columns from Update Table( dtN:dtNnames(2::dtNnamesv) ),
		Replace Columns in Main Table( None )
	);
	Close( dtN, nosave );
);

The columns to add from dtN should start at column 2 through the last column in dtN. Apparently,

2::dtNnamesv

nor other variations of it work.

Any guidance to this rather easy question would be greatly appreciated.

Re: Reference portion of array/list indirectly

jthi — Mon, 17 Jun 2024 17:08:26 GMT

Try changing

dtJ:dtJnames(r+13)

dtJ:dtJnames[r+13]

and so on (you use square brackets with indices)

mylist = {"a", "b", "c"};

Show(mylist[2::3]);

topic Re: Reference portion of array/list indirectly in Discussions

Reference portion of array/list indirectly

Re: Reference portion of array/list indirectly