I've looked everywhere and can't find a way to make NULL values in a field '0'. There's no SQL function.
Anyway to simply make null values '0'.
Thank you in advance.This message has been edited. Last edited by: FP Mod Chuck,
Windows, All Outputs
I may not properly understand your need, but in SQL you can do :
And in FOCUS within a DEFINE it can be:
NewField /I5 = IF OldField EQ MISSING THEN 0 ELSE OldField;
But none may work with Datamigrator...
WF versions : Prod 220.127.116.11M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
You can use a define in the master file as MartinY has shown then use the DEFINED field in the data flow instead of the real field.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
|Powered by Social Strata|