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?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
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.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply