Find Number of Columns

[#1]

Hi All,

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

Thanks,

Asma

[Gabriel]

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]

Hi,

You can use :

RecNo() as RawNo.

Thanks,
AS

[#4]

NoOfFields('table_name')

will return the number of column last loaded in the table