February 15, 2010 at 6:24 pm
I have a DERIVED COLUMN TRANSFORMATION as follows:
Converted_My_VALUE > 0 ? "X" : "Y"
Why doesn't this work?
It only works when the value is Greater than 0, then an "X" is plugged in.
If it's NOT Greater than 0, then a "Y" should be plugged in, but instead a NULL is inserted.
Any ideas?
February 16, 2010 at 1:07 am
Is Converted_My_VALUE always numeric, or is it sometimes NULL? Can you give an example of some of the data it contains when it is failing?
February 16, 2010 at 7:48 am
Converted_My_VALUE is a column from an EXCEL file. When I get into it's FORMAT CELL it's defined as GENERAL. It can contain blank or a number..
February 16, 2010 at 8:07 am
You question made me think just a little more.
I Googled and found out how to test for NULLs and put that equation in my DERIVED COLUMN test. Then the equation worked!
Thanks again, Phil !
February 16, 2010 at 8:38 am
A pleasure, well done for seeing it through.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply