ADF Data Flow Empty String Handling

Question

i have problems in my Data Flow with EmptyString Handling. I made an easy example (see below) which examples my problem.

1. Source: select '' as test (or any empty string of a table column)
2. DerivedColumn. New Colum EmptyStringExpression with Expression iif(test == '', 'ok', 'nok') to show the problem.
3. Sink write to table. Preview result is what i expect (see below), but in the sink table its different to the Preview, result there is 'nok'. It seems that the preview result is different to what the data flow is really writing to the sink table at the end. any help? Can't unterstand it...

emptyStringExpression

preview of the sink.

result of the table with new insert row

Answer 1

Yes of course. My original dataflow was ofcourse different, but with this example i can reproduce the problem that i had.