topic Re: Help with Value Ordering in Discussions

Help with Value Ordering

shah47 — Fri, 27 Sep 2019 16:01:31 GMT

So I want to order my column a certain way by using the Value ordering property. In this case b1, b2 and b3 are user inputs from Text Edit Box but still the ordering in the column does not follow {"Buffer", b1, b2, b3} it follows an alphabetical order.

dt = current data table();

:Results<<set property("value ordering", {"Buffer", b1, b2, b3});

I also tried the following after value ordering but it doesn't help

dt << Sort(By(:Results),Order(Ascending),Replace Table);

Re: Help with Value Ordering

ron_horne — Fri, 27 Sep 2019 16:21:33 GMT

Hi @shah47

try the following:

dt = current data table();

:Results<<set property("value ordering", {"Buffer", "b1", "b2", "b3"});

once this is correct, the sorting should work as well,

ron

Re: Help with Value Ordering

Mark_Bailey — Fri, 27 Sep 2019 16:23:41 GMT

I am not sure but try this:

:Results << Set Property( "Value Ordering", Eval List( {"Buffer", b1, b2, b3} ) );

Re: Help with Value Ordering

shah47 — Fri, 27 Sep 2019 16:39:32 GMT

Thanks all for the prompt reply, unfortunately it still reverts the column order by alphabetical

Re: Help with Value Ordering

ron_horne — Fri, 27 Sep 2019 17:33:48 GMT

Hן @shah47

can you upload a table with just that column?

Re: Help with Value Ordering

shah47 — Fri, 27 Sep 2019 18:09:13 GMT

Hi @ron_horne

I have attached the column, just to recap, the user inputs are captured as b1, b2, etc. In this instance I did a test and inputed "B" for b1 and "A" for b2 but as you can see the order in the table comes out as alphabetical.

Re: Help with Value Ordering

Thierry_S — Fri, 27 Sep 2019 18:38:10 GMT

Hi Based on the table you shared,

Here is a short script that should do what you want: just change the order of the values in the Set property call

Names Default to Here (1);

dt = Current Data Table ();

:Results << set property("value ordering", {"Blank Sample Well", "Running Buffe", "Buffer", "A", "B"});

dt << Sort( replace table, By( :Results ), Order( Ascending ) );

Re: Help with Value Ordering

shah47 — Fri, 27 Sep 2019 18:50:37 GMT

Hi @Thierry_S

Thanks but that solution will not work for what I'm trying to do. "A" and "B" are user inputs captured by b1, b2, etc with a Text Edit Box. So after the user inputs the values for b1, b2, the column order defaults to alphabetical.

Re: Help with Value Ordering

ron_horne — Fri, 27 Sep 2019 22:03:09 GMT

Hi @shah47

I think @Mark_Bailey got it right.

Pleas open the attached file and see if the scripts do the job.

names default to here (1);

a = "Running Buffe"
b1 = "B";
b2 = "A";
b3 = "Blank Sample in well";
b4 = "Buffer";
:Results << Set Property( "Value Ordering", Eval List( {a, b1, b2, b3, b4} ) );

Re: Help with Value Ordering

Thierry_S — Fri, 27 Sep 2019 22:24:18 GMT

Hi Shah,
Sorry that my short script did not do the job. I'm trying to figure out what you mean by "user inputs captured by b1, b2"? Are these numerical values or other labels for the specific assay condition?
Best,
TS

Re: Help with Value Ordering

Thierry_S — Fri, 27 Sep 2019 22:27:04 GMT

Never mind, I got it now
Best,
TS

Re: Help with Value Ordering

shah47 — Sat, 28 Sep 2019 00:29:29 GMT

@Thierry_S @ron_horne

Sorry for some of the confusion, this is the more extended version of my script

dt = current data table();
InputWindow = New Window( "Enter Input",
	<<modal(),
	Table Box(
		String Col Box( "Results",
			{"Results 01", "Results 02", "Results 03" }
		),
		Col Box(
			"Final Results",
			teb1 = Text Edit Box( "Blank Sample in wells" ),
			teb2 = Text Edit Box( "Blank Sample in wells" ),
			teb3 = Text Edit Box( "Blank Sample in wells" )			
		)
	),
	Button Box( "OK",
		b1 = teb1 << Get Text;
		b2 = teb2 << Get Text;
		b3 = teb3 << Get Text;		
	)
);
Show(s1,s2,s3,);
dt=current data table();
Try( :Results[dt << get rows where( :Raw values== "01a" )] = b1 );
Try( :Results[dt << get rows where( :Raw values== "01b" )] = b1 );
Try( :Results[dt << get rows where( :Raw values== "02a" )] = b2 );
Try( :Results[dt << get rows where( :Raw values== "02b" )] = b2 );
Try( :Results[dt << get rows where( :Raw values== "03a" )] = b3 );
Try( :Results[dt << get rows where( :Raw values== "03b" )] = b3 );

Wait(0);
dt = current data table();
:Results<<set property("value ordering", {"Buffer", b1, b2, b3});

dt = current data table();
dt << Sort(By(:Results),Order(Ascending),Replace Table);

Re: Help with Value Ordering

Thierry_S — Mon, 30 Sep 2019 00:55:54 GMT

Hi,

I'm still not clear what you are trying to do but the following slightly modified script does not return any error in the Log (see the Eval List call at the bottom)

Names Default to Here (1);

dt = current data table();
InputWindow = New Window( "Enter Input",
	<<modal(),
	Table Box(
		String Col Box( "Results",
			{"Results 01", "Results 02", "Results 03" }
		),
		Col Box(
			"Final Results",
			teb1 = Text Edit Box( "Blank Sample in wells" ),
			teb2 = Text Edit Box( "Blank Sample in wells" ),
			teb3 = Text Edit Box( "Blank Sample in wells" )			
		)
	),
	Button Box( "OK",
		b1 = teb1 << Get Text;
		b2 = teb2 << Get Text;
		b3 = teb3 << Get Text;		
	)
);
Show(b1,b2,b3,);
dt=current data table();
Try( :Results[dt << get rows where( :Raw values== "01a" )] = b1 );
Try( :Results[dt << get rows where( :Raw values== "01b" )] = b1 );
Try( :Results[dt << get rows where( :Raw values== "02a" )] = b2 );
Try( :Results[dt << get rows where( :Raw values== "02b" )] = b2 );
Try( :Results[dt << get rows where( :Raw values== "03a" )] = b3 );
Try( :Results[dt << get rows where( :Raw values== "03b" )] = b3 );

Wait(0);
dt = current data table();
:Results<<set property("value ordering", Eval List({"Buffer", b1, b2, b3}));

dt = current data table();
dt << Sort(By(:Results),Order(Ascending),Replace Table);

Re: Help with Value Ordering

shah47 — Mon, 30 Sep 2019 01:42:03 GMT

@Thierry_S

Lets say the user input the following for sample names in the text edit box:

C for b1

B for b2

A for b3

then the column order becomes "Buffer", b3, b2, b1 when I run the script, it follows an alphabetical order. I want the script to run so that the column order remains "Buffer", b1, b2, b3 no matter what is input as sample names.

Re: Help with Value Ordering

Thierry_S — Mon, 30 Sep 2019 14:20:38 GMT

Hi Shah,
I believe that the latest script I uploaded in my previous message performs the way you want. Have you tried it?
Best,
TS

Re: Help with Value Ordering

shah47 — Mon, 30 Sep 2019 14:50:02 GMT

Hi @Thierry_S

I tried your script but still the column order is alphabetical