topic Put in a list values of a table with condition in Discussions

Put in a list values of a table with condition

OrderedColt522 — Sat, 10 Jun 2023 23:48:18 GMT

I have this table :

dut | values

0 | 1638

1 | 618

2 | 486

3 | 9418

0 | 654

1 | 791

2 | 1398

3 | 4836

...

And I want put in a list, all values where the dut is 0, so have this : list = { 1638, 654 }

What syntax used ?

Re: Put in a list values of a table with condition

jthi — Fri, 13 May 2022 13:23:04 GMT

My preferred method is using with Loc, but there are many other ways to accomplish this

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(8),
	New Column("dut", Numeric, "Continuous", Format("Best", 12), Set Values([0, 1, 2, 3, 0, 1, 2, 3])),
	New Column("value", Numeric, "Continuous", Format("Best", 12), Set Values([1638, 618, 486, 9418, 654, 791, 1398, 4836]))
);

zero_rows = Loc(dt[0, "dut"], 0);
list_of_values = dt[zero_rows, "value"]; // and you can convert this to list with As List();

Re: Put in a list values of a table with condition

txnelson — Fri, 13 May 2022 15:12:04 GMT

Here is another approach to the same solution

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(8),
	New Column("dut", Numeric, "Continuous", Format("Best", 12), Set Values([0, 1, 2, 3, 0, 1, 2, 3])),
	New Column("value", Numeric, "Continuous", Format("Best", 12), Set Values([1638, 618, 486, 9418, 654, 791, 1398, 4836]))
);

theList = As List( :value[dt << get rows where( :dut == 0 )] );

Show( theList );

theList = as list(:value[dt<<get rows where(:dut == 0)])
/*:

{1638, 654}