Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to view column name from a particular table of database

Hi,

Actually I want to get all column names of a particular table say tab1 from database in qlikview

Hw to do?

3 Replies
Not applicable

How to view column name from a particular table of database

Hi Blessy,

There is an ambiguos approach in your message, in your header, you are asking about the name of a particular column and in the body, you are asking about all the column names, I've attached an example file with a possible solution.

I hope this help you.

Best regards.

Not applicable

How to view column name from a particular table of database

Hi

You didnt understand my question.Actually a particular oracle datasource contains many tables.I want to view a particular table's column names of a datasource through qlikview.

Not applicable

How to view column name from a particular table of database

Hi Blessy,

Here is again my solution:


ODBC CONNECT TO [XXX;DBQ=ZZZZZ ] (XUserId is MPBZQIRNJbaMXUVMXLSB, XPassword is UaaZNDBGSKTSUDFIMSMADYEHYA);

LOAD "OWNER", "TABLE_NAME";
SQL SELECT "OWNER", "TABLE_NAME"
FROM all_tables
where "OWNER" = 'QlikView';

LOAD "TABLE_NAME", "COLUMN_NAME";
SQL SELECT "TABLE_NAME", "COLUMN_NAME"
FROM ALL_TAB_COLUMNS
where "OWNER" = 'Qlikview';



Hope this help you.

Best regards.