1 Reply Latest reply: Feb 28, 2017 7:14 AM by Sunny Talwar RSS

    Dual Function

    Lucille Botha

      Hi all,

       

      I typically use the Dual function in my Loading Script to automatically sort values within a field.

       

      Now, I have use a SQL Select Load Statement and it does not accept my Dual Function, any assistance would be greatly appreciated.

       

      I have used the statement as follows:

       

      Case when Field = 'Name' then dual('Name', 1)

               when Field = 'Surname' then dual('Surname',2)

      end as New_Field

       

      It says that the dual function is not accepted in this format.

       

      What am I missing?

       

      thanking in you in advance,

      Lucille