FieldName

[#1]

Hi Guys

Is it possible to get the field names from the source Table but not the data. forexample by using FileBaseName() , i get name of the File only.

ForExample:

ID	Name
1	Rahul
2	John

When i load the above table in Qlikview ,i should get one column containing the Name of the Field (i.e. ID and Name) but no data.

i only need field names. Is it possible????????

[sivarajs]

The keyword NoOffields count the fields based on already loaded data.So if you wont give it will give error in for loop

[rupamjyotidas]

Any way to get the values of all fields inside a New Field or Is it possible to get the field values from the source Table.

[its_anandrjs]

Hi Manish,

You can try with this will not load any rows

Load

Id,

Name

Where RowNo() = 1;

[#5]

I would suggest to first load your data files (xls and such) and save them as QVD files. This has a number of benefits,  one being that you can use the following to get the fieldnames and numberof fields in the data file :

QvdFieldName(qvd_file_name, field_no)

and

QvdNoOfFields (qvd_file_name)

[Kushal_Chawda]

Hi Manish,

In Oracle you can use the below query. What is your source database?

SELECT column_name
FROM all_tab_cols
WHERE table_name = 'users'
  AND owner = ' || +_db+ || '
  AND column_name NOT IN ( 'password', 'version', 'id' )


[MarcoWedel]

old thread, but one solution could be:

tabFields:
CrossTable (FieldName, val) LOAD 1,*
FROM Source
Where RecNo()=1;

DROP Fields '1', val;

maybe it helps

regards

Marco

[its_anandrjs]

Did you try this load script

Load

Id,

Name

Where RowNo() = 1;

Regards

Anand