How to view column name from a particular table of database

[#1]

Hi,

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

Hw to do?

[#2]

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.

[#3]

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.

[#4]

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.