755653_en-US

liliconcom

Automatically plot associated columns

I have a data table containing voltage values associated with a structure of a particular size.  I also have a column describing the current resulting from the applied voltage for the same structure size.  When there are a large quantity of such columns, is there a way to have the columns that are related be plotted without any of the other unassociated plots being generated as a result?  I can of course plot them all and minimise the ones that don't associate but I wondered if Regex or the likes could simplify the task?

Automation and ScriptingRe: Automatically plot associated columns

What you describe sound like the Local Data Filter ...

 

[edit]

Oh, sorry, it doesn't 

Re: Automatically plot associated columns

I figured this one out I think.  Excuse the clumsy check list boxes, they need a lot of work but otherwise, the formula associates the selected metrics by matching the characters beyond the first 3.  I can ensure the voltage threshold plots only against the relevant current for instance while also assessing multiple metrics in a single process.

 

SpannerHead

dt = Current Data Table();
dt << Clear Column Selection();
colList = dt << get column names( string );
check_list1 = {"VTX", "VTN", "VTP", "VTF", "IDS", "IBB", "ILK", "CMI"};
check_list2 = {"VTX", "VTN", "VTP", "VTF", "IDS", "IBB", "ILK", "CMI"};
nw = New Window( "X Value",
	<<MODAL></MODAL>

Thanks for the suggestions

 

 

Re: Automatically plot associated columns

Hello-

It sounds like you have found a workable solution- that's great.  There are usually several ways to approach a problem, and sometimes others can benefit from tips/tricks learned here.

>>I will admit that I was unsure of the exact problem from your description, a sample illustration would have been helpful.
Some thoughts on "a" problem (if it incorrectly matches yours- perhaps others will find some use).

Column Select has filter options under the red Triangle

Depending on the nature of your column names- the search may allow groups of the type you desire.

 

 

 

Re: Automatically plot associated columns

it would be helpful to have a sample data table, and a mockup of what you want the graph to look like.