Solved: How to get the Fieldname? - Qlik Community

Anonymous · ‎2011-01-04

I want to get the Fieldname from document as values into a field.

For example, when I load data from an Excel file, it can load all field's name as a new field from this .xls file as well.

Miguel_Angel_Baeyens · ‎2011-01-04

Hello,

You can create a new listbox with $Field as field. It's a system field and it's available in any document with some tables loaded.

Hope this helps.

Miguel_Angel_Baeyens · ‎2011-01-04

Hello,

You can create a new listbox with $Field as field. It's a system field and it's available in any document with some tables loaded.

Hope this helps.

tresesco · ‎2011-01-04

Hi,

For this you have to create an ODBC/OLEDB connection. and then you can use command -"SQLColumns" to get the names of the fileds under the field COLUMN_NAME. for detail understanding you can refer to the following link : http://community.qlik.com/blogs/qlikviewblogs/archive/2008/09/29/loading-multiple-excel-sheets.aspx

regards, tresesco

guytzumer · ‎2011-01-04

Or jest use the crosstable function ... Depends what you need

Anonymous · ‎2011-01-04

Thank you everybody, using $Field is just OK for me.