3 Replies Latest reply on Sep 2, 2020 11:40 AM by Kevin Wells

    Connected Lookup Transformation - pass the text 'UNKNOWN' if not found.

    Kevin Wells Seasoned Veteran

      I have a connected lookup transformation in my mapping.  What I would like to do is return "UNKNOWN" vs passing NULLs to my TGT table if no match is found. 

       

      Is it possible to do this? If so, any insight would be appreciated.

       

      Thanks you.