topic Re: dt: image - missing? in Discussions

dt: image - missing?

hogi — Sun, 31 Mar 2024 14:41:50 GMT

What is the correct way to check if an image in a data table is missing?

... and why is there a difference between the column formula and the JSL question

is missing(:pet[5])

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" );
dt[[4],"pet"]=.;

New Column( "is missing",Formula( Is Missing( :pet ) ));

New Column( "is empty",	Formula( Is Empty( :pet ) ));

New Column( "is number",Formula( Is Number( :pet ) ));

New Column( "is expr",Formula( Is expr( :pet ) ));

write("is missing:");
Show(is missing(:pet[4]));
Try(Show(is missing(:pet[5])), Print("is missing: error with existing image"));

write("\!n\!nis empty");
Show(is empty(:pet[4]));
Show(is empty(:pet[5]));

write("\!n\!nis number");
Show(is number(:pet[4]));
Show(is number(:pet[5]));

write("\!n\!nis expr");
Show(is expr(:pet[4]));
Show(is expr(:pet[5]));

Re: dt: image - missing?

Craige_Hales — Sun, 31 Mar 2024 15:34:08 GMT

I find the isMissing() function hard to use. It does not do what I want it to do when its argument is not a number, or maybe a string. Try this:

is number(:pet[5]) & is missing(:pet[5])

Re: dt: image - missing?

Craige_Hales — Sun, 31 Mar 2024 15:42:16 GMT

And a better answer for the actual question:

New Column( "type",Formula( type( :pet ) ));
type(pet[5])

The type in your example is either "Picture" or "Number".

And the other question: The column formula is likely coming up with a string value for the expression. You can use isMissing on a string. You can make the JSL behave the same way, like this:

row()=5;ismissing(:pet)

Re: dt: image - missing?

jthi — Sun, 31 Mar 2024 15:45:37 GMT

It can be a mess in JMP to check if objects are empty, missing, null, none, have no items and you will very quickly end in a situation which requires multiple checks to avoid different types of errors. I have created wish list item to have some sort of universal type of function Is None? to check if objects/variables/... are empty/missing