I want to post the result of a query to a variable and evaluate.

[Robert Fuschetto 2]

I believe I did this years ago but cannot find the fex. I want to create a hold file. The result will be a single row with 'Units' summed. I want to store the single resultant units to a variable. I then want to do an IF Units> 0 Then run fex1 Else run fex 2.

I do not recall how I did this and cannot find anything in the guide.

Thanks!

[Patrick Huebgen 2]

@Robert Fuschetto​ Just discussed this in another topic - https://community.spotfire.com/s/question/0D74z00000BI1yrCAD/

here's the sample code

-SET &HOW_MANY = 0;TABLE FILE CARSUM COMPUTE HOW_MANY/I11=CNT.SALES ;ON TABLE HOLD AS TEST FORMAT ALPHAEND-RUN-READFILE TEST-TYPE HOWMANY &HOW_MANY

[Mat Barnard]

-IF &HOW_MANY GT 0 THEN GOTO :WE_HAVE_RECS ELSE GOTO :WE_HAVE_NO_RECS; -:WE_HAVE_RECS EX WE_HAVE_RECS -EXIT -:WE_HAVE_NO_RECS EX WE_HAVE_NO_RECS -EXIT

You can swap out the EX for INCLUDE if you so chose.

[Mat Barnard]

Or even:

-SET &EX = IF &HOW_MANY GT 0 THEN 'WE_HAVE_RECS' ELSE 'WE_HAVE_NO_RECS'; EX &EX

[Robert Fuschetto 2]

Thanks..actaully I really just need to evaluate and set a variable to a string and then use the string in my page header!

Something like:

MESSAGE A200 = IF UNITS < 100 THEN 'Note full refresh has not completed' ELSE 'Refresh Completed'

[Patrick Huebgen 2]

@Robert Fuschetto​ Even easier

TABLE FILE CARSUM SALES COMPUTE MESSAGE/A200= IF SALES LT 300000 THEN 'Note full refresh has not completed' ELSE 'Refresh Completed'; NOPRINTHEADING"<MESSAGE"END

[Patrick Huebgen 2]

Or the Amper version

-SET &MESSAGE = 0; TABLE FILE CAR SUM  SALES COMPUTE MESSAGE/A200= IF SALES LT 300000 THEN 'Note full refresh has not completed' ELSE 'Refresh Completed'; NOPRINT ON TABLE HOLD AS TEST FORMAT ALPHA HEADING "<MESSAGE" END -RUN -READFILE TEST -TYPE MESSAGE &MESSAGE

[Robert Fuschetto 2]

THANKS!