- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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"];
);
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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"];
);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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"];
);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Get column Property and store as list
It worked, Thanks for quick Reply.