Field Containing Single Period Gets Transformed to NULL

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/5491089191

October 20, 2006, 11:26 AM

smiths

Field Containing Single Period Gets Transformed to NULL

The ETL tool transforms a field with a single period to NULL (since the period is the identifier for a NULL field in WebFocus).

Is there any way (or setting) to ensure that the data gets transformed as a single period? Perhaps something that can be set in the source master file....?

Thanks,
Sean

------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode

November 14, 2006, 04:55 PM

j.gross

I would expect MISSING=ON/OFF in the FIELDNAME entry to control this behavior.

- Jack Gross
WF through 8.1.05