topic Get column Property and store as list in Discussions

Get column Property and store as list

RK1 — Thu, 08 Feb 2018 00:54:47 GMT

I have a large data set and each column has spec limit i am looping through the column names and trying to get spec Limit and storing them as a list. But somehow script is not storing the values of spec Limits in a list and giving only values for last iteration.

any help on how to store spec values as list ?

data_cols = dt1 << Get Column Names (continuous);

lsl= {};

usl={};

for (m =1,m<=NItems(data_cols),m++,

specs = Column(dt1,char(data_cols[m])) << get property ("Spec Limits");

lsl= specs["LSL"];
usl = specs ["USL"];

);

Re: Get column Property and store as list

txnelson — Thu, 08 Feb 2018 03:08:39 GMT

Your code just kept replacing the complete value of the lists, LSL and USL; See below for solution

dt1 = Current Data Table();

data_cols = dt1 << Get Column Names( continuous );

lsl = {};

usl = {};

For( m = 1, m <= N Items( data_cols ), m++, 

	specs = Column( dt1, Char( data_cols[m] ) ) << get property( "Spec Limits" );

	lsl[m] = specs["LSL"];
	usl[m] = specs["USL"];

);

Re: Get column Property and store as list

RK1 — Thu, 08 Feb 2018 17:26:57 GMT

It worked, Thanks for quick Reply.