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,