I would like to extend the behavior of the Derived column data flow
transform. How do I do that?

Hello John,

In what way would you like to extend it? My initial thoughts are that you
will need to write your own transform but if you tell us what you want to
do then we may be able to do something with the stock tasks.

Allan

I want to offer more options in the UI. For example I know something about
the destination so I can identify defaults and required columns. Also, i
would like to build a case statement as an expression.

-John

"Allan Mitchell" wrote:

Hello John,

You can already use a CASE type expression

GeneratedInt_1 > 2 ? "Here" : "There"

<Expression to evaluate> ? <True result> : <False result>

I can't seem to nest them so how what does the expression look like when I
want to say

case <expression>
case 1: <result>
case 2: <result>
case 3: <result>
.......



"Allan Mitchell" wrote:

Hello John,

So how about this


col1 == 1 ? "Yes==1" : col1 == 2 ? "Yes==2" :col1 == 3 ? "Yes==3" : "None
Of the above"

Allan