topic Re: use 'with' clause sql statement in data load editor in Visualization and Usability https://community.qlik.com/t5/Visualization-and-Usability/use-with-clause-sql-statement-in-data-load-editor/m-p/1278909#M86355 <HTML><HEAD></HEAD><BODY><P>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: <A href="https://community.qlik.com/thread/176559">how to use with clause (pl sql) in qlikview</A></P></BODY></HTML> Wed, 15 Feb 2017 12:08:19 GMT sunny_talwar 2017-02-15T12:08:19Z use 'with' clause sql statement in data load editor https://community.qlik.com/t5/Visualization-and-Usability/use-with-clause-sql-statement-in-data-load-editor/m-p/1278908#M86354 <HTML><HEAD></HEAD><BODY><P>I tried to use 'with' clause sql statement&nbsp; in data load editor but qliksense cannot recognise. Is it because 'with' is not recognised by qlik or I have made a mistake?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/153177_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 15 Feb 2017 12:00:33 GMT https://community.qlik.com/t5/Visualization-and-Usability/use-with-clause-sql-statement-in-data-load-editor/m-p/1278908#M86354 2017-02-15T12:00:33Z Re: use 'with' clause sql statement in data load editor https://community.qlik.com/t5/Visualization-and-Usability/use-with-clause-sql-statement-in-data-load-editor/m-p/1278909#M86355 <HTML><HEAD></HEAD><BODY><P>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: <A href="https://community.qlik.com/thread/176559">how to use with clause (pl sql) in qlikview</A></P></BODY></HTML> Wed, 15 Feb 2017 12:08:19 GMT https://community.qlik.com/t5/Visualization-and-Usability/use-with-clause-sql-statement-in-data-load-editor/m-p/1278909#M86355 sunny_talwar 2017-02-15T12:08:19Z Re: use 'with' clause sql statement in data load editor https://community.qlik.com/t5/Visualization-and-Usability/use-with-clause-sql-statement-in-data-load-editor/m-p/1278910#M86356 <HTML><HEAD></HEAD><BODY><P>Add SQL in front of 'with' for my case to make it work.</P></BODY></HTML> Wed, 15 Feb 2017 12:24:02 GMT https://community.qlik.com/t5/Visualization-and-Usability/use-with-clause-sql-statement-in-data-load-editor/m-p/1278910#M86356 2017-02-15T12:24:02Z Re: use 'with' clause sql statement in data load editor https://community.qlik.com/t5/Visualization-and-Usability/use-with-clause-sql-statement-in-data-load-editor/m-p/1511941#M120013 <P>use sql command</P> Mon, 26 Nov 2018 04:01:35 GMT https://community.qlik.com/t5/Visualization-and-Usability/use-with-clause-sql-statement-in-data-load-editor/m-p/1511941#M120013 jafari_ervin 2018-11-26T04:01:35Z