Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dual Function

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

1 Reply
sunny_talwar

May be use Dual in Preceding Load