HomeForum
Welcome, Guest

Dealing with nulls
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Dealing with nulls

Dealing with nulls 11 months, 3 weeks ago #2865

  • Ron
  • OFFLINE
  • Junior Boarder
  • Posts: 22
  • Karma: 0
I have data coming in from the text file as NULL.
The SQL field being loaded is a character field. I'd like to change that NULL to a space. I am doing it now with a SQL after but just wondered if there is a way to do it in the load.

Thanks

Ron

Re: Dealing with nulls 11 months, 3 weeks ago #2866

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Use calculations + replace function

There are some examples in the documentation

Peter
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

"Advanced ETL Processor is superior software... I highly recommend this to anyone who is building datawarehouse. I would and I  have recommended it to many colleagues and customers."

- Peter Jonson, Data Integration Consultant, MPI

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top