Validate Graph output is not blank before saving

senatorx

Hey,

I am creating graphs with multiple "Where" conditions that can result in no output, depending on the contents of the data file.

Where(:Column 1 == "string1" & :Column 2 == "string2" & :Column 3 == "string3")

If I then try to save a graph that is blank, the script crashes:

GraphName <<  /*###*/save picture( SaveString, png ) /*###*/;

How can I validate that the Graph contains data prior to attempting to save it?

Thanks!

pmroz

I would use something like:

dt << clear row states;

selected_rows = dt << get rows where(:Column 1 == "string1" &

                                     :Column 2 == "string2" &

                                     :Column 3 == "string3");

if (nrows(selected_rows) > 0,

    dt << select rows(selected_rows) << invert row selection

       << exclude << clear select;

   

    .

    .

//    Create your graph here

    .

    .

);