input Column 0 value to NULL in target
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 58
- Joined: Mon Dec 14, 2015 3:16 pm
- Location: Arizona
input Column 0 value to NULL in target
How to convert source Input value that is 0 to NULL in target DB
anudpETL
-
- Participant
- Posts: 58
- Joined: Mon Dec 14, 2015 3:16 pm
- Location: Arizona
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Makes no difference to what Craig suggested.
You'll need to convert the string to a date if it's valid, otherwise set the value to null. Do these things in a Transformer stage.
Something like:
You'll need to convert the string to a date if it's valid, otherwise set the value to null. Do these things in a Transformer stage.
Something like:
Code: Select all
If (IsValid(InLink.TheString, "date")) Then StringToDate(InLink.TheString) Else SetNull()
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.