topic Re: FieldName in QlikView

FieldName

Wed, 10 Oct 2012 09:23:38 GMT

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????????

Re: FieldName

MayilVahanan — Wed, 10 Oct 2012 09:26:20 GMT

Try like this

Load * from tablename where 1=1;

Hope that helps

Gives only field name

Re: FieldName

Wed, 10 Oct 2012 09:35:15 GMT

Hi,

You can use FieldName() function.

Ex.

FieldName(1,'Table1') will retrieve the first fieldname from Table1.

Regards,

Janzen

Re: FieldName

Wed, 10 Oct 2012 09:37:47 GMT

I guess you meant "WHERE 1=2".

Since 1=1 will fetch all the records while 1=2 will fetch none.

Re: FieldName

Anonymous — Wed, 10 Oct 2012 09:42:26 GMT

Hi,

Use the function NoOfFields(tablename) to get number of fields from your table.

Then use a loop For next on each field and get the name with the function fieldName(FieldNo,tablename).

Create dynamicly into the loop a table containing fields names.

Regads

Re: FieldName

MayilVahanan — Wed, 10 Oct 2012 09:44:43 GMT

Hi Hulk,

Ya want to use where 1= 2 condition..

Load * from tablename where 1=2;

Wrongly typed..Thnx

Re: FieldName

Wed, 10 Oct 2012 10:54:58 GMT

Hi guys thanks For replies..... but i want that when i load the table into Qlikview then i should get a column that will give me name of all Fields in that table .......

For example

Load

________ as FieldNames

From TableName;

I do not want any fields with data

Re: FieldName

Anonymous — Wed, 10 Oct 2012 11:24:50 GMT

Do like this:

FOR fieldNo = 1 to NoOfFields('tablename')

let _fieldName = fieldName($(fieldNo), 'tablename');

TABLE_FIELDS:

LOAD

'$(_fieldName)' as FIELD_NAME

autogenerate 1;

Before this script, you need to load the table, and then drop it if you don't want data.

Regards

Re: FieldName

sivarajs — Wed, 10 Oct 2012 12:41:02 GMT

Check the attached file

Re: FieldName

Wed, 10 Oct 2012 18:13:45 GMT

Can i do it without loading the table into qlikview first??? i mean to say that directly from the source table load the field names into one column?????

Re: FieldName

sivarajs — Thu, 11 Oct 2012 05:01:57 GMT

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

Re: FieldName

rupamjyotidas — Wed, 18 Jun 2014 17:53:23 GMT

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.

Re: FieldName

its_anandrjs — Wed, 18 Jun 2014 18:03:28 GMT

Hi Manish,

You can try with this will not load any rows

Load

Id,

Name

Where RowNo() = 1;

Re: FieldName

Thu, 30 Oct 2014 10:01:12 GMT

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)

Re: FieldName

Kushal_Chawda — Thu, 30 Oct 2014 10:17:35 GMT

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' )

Re: FieldName

MarcoWedel — Thu, 30 Oct 2014 11:28:56 GMT

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

Re: FieldName

its_anandrjs — Thu, 30 Oct 2014 11:32:07 GMT

Did you try this load script

Load

Id,

Name

Where RowNo() = 1;

Regards

Anand