topic Re: Load SQL table without knowing field names. in QlikView

Load SQL table without knowing field names.

Thu, 28 Apr 2016 15:42:42 GMT

Hi All,

I have a new database that I am connecting to and i would like to use QlikView to show me all of the field names available in a certain table.

I have tried:

LOAD VISITS;

SQL SELECT *.*

FROM VISITS;

This throws an error , am i unable to use a wild card for fields?

Thanks

Wayne

Re: Load SQL table without knowing field names.

sunny_talwar — Thu, 28 Apr 2016 15:51:48 GMT

Try this:

LOAD *;

SQL SELECT *

FROM VISITS;

Then check all the field names on the front end

Re: Load SQL table without knowing field names.

pooja_sn — Thu, 28 Apr 2016 15:54:34 GMT

Below SQL script will return all the column names from a SQL table:

SQL

select COLUMN_NAME

from INFORMATION_SCHEMA.COLUMNS

where TABLE_NAME='table_name'

Re: Load SQL table without knowing field names.

Thu, 28 Apr 2016 16:04:00 GMT

Hi,

I am able to access from Qlikview but this script is accessing the server directly?

Re: Load SQL table without knowing field names.

Thu, 28 Apr 2016 16:04:46 GMT

I am connecting with an ODBC connection through QlikView?

Re: Load SQL table without knowing field names.

MarcoWedel — Thu, 28 Apr 2016 16:21:07 GMT

Hi,

maybe helpful:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptRegularStatements/SQLColumns.htm

Regards

Marco

Re: Load SQL table without knowing field names.

johnw — Thu, 28 Apr 2016 16:51:59 GMT

That's how I do it.

Re: Load SQL table without knowing field names.

johnw — Thu, 28 Apr 2016 16:54:37 GMT

However you would normally connect to your database management system through QlikView. We use ODBC here.

Re: Load SQL table without knowing field names.

johnw — Thu, 28 Apr 2016 16:55:58 GMT

You could do it on the server, but as shown it will run from QlikView. However, that script will depend heavily on your environment, I believe. At our company, for instance, it would look more like:

LOAD *
;
SQL
SELECT NAME
FROM SYSIBM.SYSCOLUMNS
WHERE TBCREATOR = 'SYSTLC'
AND TBNAME = 'VISITS'
;

But when I want to know the field names in a table, I do it like Sunny T suggested.