locked
Dataflow: iif with a null() and toBinary options problem RRS feed

  • Question

  • Hi

    I'am trying to make the following expression work but I get the error "Expression should return the same type 'null' as previous expressions" with the "toBinary ..." part underlined in red"

    iif(isNull($$), null(),toBinary(sha2(256, $$))))

    How can I specify a "binary" null?

    Thanks!

    Paul

    Friday, August 23, 2019 1:37 PM

All replies

  • iif(isNull($$), toBinary(null), toBinary(sha2(256,$$))))

    Tuesday, August 27, 2019 12:31 AM
  • When I try toBinary(null) I get a message stating "column not found" 

    

    I tried toBinary(null()) and the expression evaluated correctly but I got 

    "GetCommandOutputAsync failed with User Error: DF-FN-022 - toBinary does not accept null - [345 200 271 382 483 616],"

    when executing the dataflow...

    Wednesday, August 28, 2019 1:21 PM