Choose Language Hide Translation Bar
RK1
RK1
Community Trekker

Get column Property and store as list

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"];

);

 

 

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Get column Property and store as list

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"];

);
Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Get column Property and store as list

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"];

);
Jim

View solution in original post

RK1
RK1
Community Trekker

Re: Get column Property and store as list

It worked, Thanks for quick Reply.

0 Kudos