topic NoConcatenate SQL Select in QlikView

NoConcatenate SQL Select

lucarizziero — Wed, 03 Nov 2010 11:03:16 GMT

Hi All,

I need to use the NoConcatenate option with an SQL Select statement: in the documentation it seems possible but It seems I'm not using the correct syntax.

The user manual show the noconcatenate load instruction only, while the noconcatenate sql select doesn't run.

Thanks

NoConcatenate SQL Select

Wed, 03 Nov 2010 11:07:16 GMT

Hello,

try

MyTab:
noconcatenate LOAD
*
;
SQL SELECT ...

hth,
Thilo

NoConcatenate SQL Select

lucarizziero — Wed, 03 Nov 2010 11:17:14 GMT

Hi Thilo,

Thanks a lot: it runs !