topic Re: If Statement to add a yes/no column in Discussions

If Statement to add a yes/no column

ChrisNally — Sat, 10 Jun 2023 23:19:38 GMT

Good Morning

Any help here would be much appreciated. I am trying to add a new column that will add either a yes or a no based on a Bx no. range

So in table below any Bx No before 10732 would return a "Yes" in the 0.3mic column and any Bx No after would return a "No".

Thanks in advance.

Chris

C_LOT_NAME	PRODUCT	SAMPLE_TYPE	Average Pigment Strength	0.3mic filtered
10128	CYAN_J2V	LOT_FINISHED
10128	CYAN_J2V	LOT_FINISHED	10.14
10200	CYAN_J2V	LOT_FINISHED	12.26
10200	CYAN_J2V	LOT_FINISHED
10240	CYAN_J2V	LOT_FINISHED	12.06
10240	CYAN_J2V	LOT_FINISHED
10377	CYAN_J2V	LOT_FINISHED	11.965
10487	CYAN_J2V	LOT_FINISHED	12.145
10487	CYAN_J2V	LOT_FINISHED	12.075
10634	CYAN_J2V	LOT_FINISHED
10634	CYAN_J2V	LOT_FINISHED	12.195
10682	CYAN_J2V	LOT_FINISHED	12.035
10697	CYAN_J2V	LOT_FINISHED	12.1
10732	CYAN_J2V	LOT_FINISHED	12.13
10733	CYAN_J2V	LOT_FINISHED	12.265
10871	CYAN_J2V	LOT_FINISHED	12.155
10872	CYAN_J2V	LOT_FINISHED	12.155
10873	CYAN_J2V	LOT_FINISHED	12.035
10874	CYAN_J2V	LOT_FINISHED	12.145

Re: If Statement to add a yes/no column

ChrisNally — Mon, 28 Sep 2020 10:33:28 GMT

I tried this but only get No returned in the column:

dt << New Column( "0.3mic filtered ",
    Character,
    Nominal,
    Formula(
        If(
            :C_LOT_NAME == "<10732"
        ,
            "YES",
            "No"
        )
    )
);

Re: If Statement to add a yes/no column

txnelson — Mon, 28 Sep 2020 08:31:56 GMT

Try this

dt << New Column( "0.3mic filtered ",
	Character,
	Nominal,
	Formula(
		If( Num( :C_LOT_NAME ) < 10732,
			"YES",
			"No"
		)
	)
);

Re: If Statement to add a yes/no column

ChrisNally — Mon, 28 Sep 2020 08:45:37 GMT

Thank you very much, this worked well. Your help is much appreciated.

Regards

Chris