use 'with' clause sql statement in data load editor

[#1]

I tried to use 'with' clause sql statement  in data load editor but qliksense cannot recognise. Is it because 'with' is not recognised by qlik or I have made a mistake?

[sunny_talwar · Accepted solution]

Do you have a ODBC connection? I think you might need ODBC, if you don't have that. Also, look here if this thread can provide any information: how to use with clause (pl sql) in qlikview

[#3]

Add SQL in front of 'with' for my case to make it work.

[jafari_ervin]

use sql command