Load SQL table without knowing field names.

[#1]

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

[sunny_talwar]

Try this:

LOAD *;

SQL SELECT *

FROM VISITS;

Then check all the field names on the front end

[pooja_sn]

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'

[#4]

Hi,

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

[#5]

I am connecting with an ODBC connection through QlikView?

[MarcoWedel]

Hi,

maybe helpful:

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

Regards

Marco

[johnw]

That's how I do it.

[johnw]

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

[johnw]

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.