Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
LOAD *;
SQL SELECT *
FROM VISITS;
Then check all the field names on the front end
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'
Hi,
I am able to access from Qlikview but this script is accessing the server directly?
I am connecting with an ODBC connection through QlikView?
Hi,
maybe helpful:
Regards
Marco
That's how I do it.
However you would normally connect to your database management system through QlikView. We use ODBC here.
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.