topic Re: How to distinguish whether there are empty values in a column? in Discussions

How to distinguish whether there are empty values in a column?

BabyDoragon — Tue, 25 Mar 2025 08:31:47 GMT

I want to distinguish whether the cells in the column are empty using "is missing". In the JSL below, I hope to differentiate between the "name" and "Apple" fields, but the results are all 1. How should I modify it?

 dtTest = Open( "$SAMPLE_DATA/Big Class.jmp" );
 show(IsMissing(:age));
 dtTest << New Column( "Apple", "Character", "Nominal" );
 show(IsMissing(:Apple));

Re: How to distinguish whether there are empty values in a column?

jthi — Tue, 25 Mar 2025 08:38:25 GMT

Do you wish to check if all values are missing? You can for example use Col Number and check if it is 0

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

dt << New Column("Apple", "Character", "Nominal");
dt << New Column("Orange", Numeric, Continuous);


Show(Col Number(Column(dt, "age")) == 1);
Show(Col Number(Column(dt, "Apple")) == 1);
Show(Col Number(Column(dt, "Orange")) == 1);

Re: How to distinguish whether there are empty values in a column?

BabyDoragon — Tue, 25 Mar 2025 08:54:59 GMT

I confirmed that all three results are displayed as 0, but in reality, the age field has a value. This makes it impossible to distinguish between the Apple and Orange fields.

Re: How to distinguish whether there are empty values in a column?

jthi — Tue, 25 Mar 2025 09:04:33 GMT

Check for 0 not for 1

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

dt << New Column("Apple", "Character", "Nominal");
dt << New Column("Orange", Numeric, Continuous);


Show(Col Number(Column(dt, "age")) == 0);
Show(Col Number(Column(dt, "Apple")) == 0);
Show(Col Number(Column(dt, "Orange")) == 0);