Check if multiple column values fall within range

hooshies

Sample table:

Part	Test 1	Test 2	Test 3	Test 4
A	0.2	0.4	0.3	0.1
B	0.2	0.3	0.4	0.6
C	0.7	0.1	0.2	0.4

I would like to add a column to this table that evaluates every value in columns Test 1-Test 4, and if all fall within a range to output "Yes".

For example, if my range was 0 < values < 0.5, the output would look like this (I've highlighted failing values in red)

Part	Test 1	Test 2	Test 3	Test 4	Yes/No
A	0.2	0.4	0.3	0.1	Yes
B	0.2	0.3	0.4	0.6	No
C	0.7	0.1	0.2	0.4	No

Is there a simple way to achieve this with JSL?

ron_horne

hi hooshies,

to answer your exact question the following script can do it.

A more general solution  depends on the aspect that needs generalizing (i.e. more columns, different ranges for different columns and whether you want it in a column formula or just to be calculated once by jsl)

dt = New Table( "Data source",

     Add Rows( 3 ),

     New Column( "Part", Character, Nominal, Set Values( {"A", "B", "C"} ) ),

     New Column( "Test 1", Set Values( [0.2, 0.2, 0.7] ) ),

     New Column( "Test 2", Set Values( [0.4, 0.3, 0.1] ) ),

     New Column( "Test 3", Set Values( [0.3, 0.4, 0.2] ) ),

     New Column( "Test 4", Set Values( [0.1, 0.6, 0.4] ) ),

);

dt << New Column( "Yes/No",

     Character,

     Nominal,

     Formula(

          If(

              Maximum(

                   Abs( :Test 1 ),

                   Abs( :Test 2 ),

                   Abs( :Test 3 ),

                   Abs( :Test 4 )

              ) > 0.5,

              "No",

              "Yes"

          )

     )

);