topic load fieldnames from ODBC in QlikView

load fieldnames from ODBC

Tue, 17 Apr 2012 15:08:08 GMT

Hi,

i have to add this statement load *; before sql select * from ODBC

but i wanna see as

load A, B, C, ...all field names sql select * from ODBC

and select field names automtically (not to be have to write by hand)

thanks

Re: load fieldnames from ODBC

Tue, 17 Apr 2012 15:11:16 GMT

If you use the wizard and check the box for preceding load it should do this automatically.

load fieldnames from ODBC

Gabriel — Tue, 17 Apr 2012 15:13:55 GMT

Hi merakist,

I think what you have to do is select each fieldname one at a time (i.e. select A, B, C separately by clicking each field ) and it will appear in the selection box below.

Let me know if thisis not clear enough.

Regards,

Gab

load fieldnames from ODBC

hallquist_nate — Tue, 17 Apr 2012 15:26:57 GMT

I think all you really need to do is check the box "Preceeding Load" in the Create Select Statement Dialog box. That allows you to then select only the fields you need and lists each one in the load script. Be sure to click Add, before OK.

load fieldnames from ODBC

Tue, 17 Apr 2012 15:34:48 GMT

@marcsliving and @gabsus04

thanks a lot.