data flow expression

Question

data flow expression

arkiboys 9,711

data coming in is as yyyy-MM-dd

I'd like to have an expression where
if the date value < 2010-01-01 then leave as is
if the date value > 2010-01-01 then format it to dd/MM/yyyy

This is what I have but it gives null if the date > 2010-01-01

iif((toDate(toString(byName($0)),Config#lookup($0).SourceFormat)) < (toDate('2010-01-01')),toDate(toString($$)),toDate(toString(toTimestamp(toString(byName($0)), Config#lookup($0).SourceFormat) , 'dd/MM/yyyy')))

0 comments

1 answer

Your answer

Answer 1

MarkKromer-MSFT 5,231 Microsoft Employee Moderator

Try using $$ instead of $0

arkiboys 9,711 Reputation points

2021-11-16T03:44:04.89+00:00

I see...
In that case, in derived column inside mapping dataflow, in value expression, I tried expr(Config#lookup($0).Expression) but it errors with java nullpointer exception
I basically would like to execute the expression once it is evaluated as upper($$) in this case which is really converting my text string to expression
For example, if I try: expr ('upper($$)') then it data preview, it just shows 'upper($$)' in the column values and it does not capitalize the values. if I just use upper($$) then the values are capitalized. I would like to have expression executed dynamically but it looks like it is not possible in derived column?
expr ('<dynamic content>') --> does not seem to work in derivedcolumn but it does seem to work in filter activity as per Mark's youtube video

Thank you

Share via

data flow expression

1 answer

Your answer