topic Re: Find Number of Columns in QlikView

Find Number of Columns

Tue, 12 May 2015 11:46:22 GMT

Hi All,

Is it possible to find out the number of columns present in an excel sheet in the script?

Thanks,

Asma

Gabriel — Tue, 12 May 2015 12:02:44 GMT

Hi,

In the script after you've loaded the excel file then use NoOfFields() function'

So in script below, vFieldNo in UI will give you the number of columns in excel.

MyTable:

LOAD

from ExcelSource

;

LET vFieldNo = NoOfFields('MyTable');

amit_saini — Tue, 12 May 2015 12:04:09 GMT

Hi,

You can use :

RecNo() as RawNo.

Thanks,
AS

Tue, 12 May 2015 12:16:59 GMT

NoOfFields('table_name')

will return the number of column last loaded in the table