On 12/17/2012 05:46 PM, Adrian Klaver wrote:
> 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.
>
>
Although it may be overkill for a simple case like this, especially if
it is a one-time load, there are plenty of open-source ETL tools out
there: https://www.google.com/search?q=open+source+etl
Cheers,
Steve