On 12/17/2012 05:30 PM, Kirk Wythers wrote:
> Thanks.
>
> Is there a way to use the float4 data type for a variable when empty
> records contain "NA", instead of nothing? As you can see below the
> variable "A_TC_AVG1" has the first record filled with "NA" signifying
> that the record is empty? Records that contain values will have decimal
> values like 12.3456.
>
Either preprocess the data to turn NA into NULL or put the data into a
staging table that is looser about types (i.e. use varchar for this
column) and then transform in place and then move over into the final table.
--
Adrian Klaver
adrian.klaver@gmail.com